Good Day Everyone.
Need your expert guidance to be able to create a dynamic template that users will be filling information with.
In file "Inputs.xlsx" the "Input-1" sheet is what will go into every file based on "data filed" and "file name" from sheet "Input-2". This should create me 7 new files with file name as in "Unique File Name". Every column in "Data Field" needs to be appended as a column header to "Input-1".
The New headings for each file is as below:
DOTY-Dealer Standards CI.xlsx
| ID | CealerCD | DealerName | Town | Region | Dist | Category | Dealer Standards CI |
| 1 | 1111 | Citrusdal | Citrusdal | 1 | 32 | E | |
| 2 | 0022 | Krugersdorp | Krugersdorp | 1 | 12 | B | |
| 3 | 1122 | Louis Trichardt | Louis Trichardt | 1 | 32 | D | |
| 4 | 1124 | Malmesbury | Malmesbury | 1 | 32 | E | |
| 5 | 1119 | Modimolle | Modimolle | 1 | 32 | E | |
| 6 | 1118 | Mokopane | Mokopane | 1 | 32 | D | |
| 7 | 9111 | Moorreesburg | Moorreesburg | 1 | 32 | E | |
| 8 | 9110 | North West | Lichtenburg | 1 | 32 | D | |
| 9 | 9110 | North West | Zeerust | 1 | 32 | D | |
| 10 | 9004 | Roodepoort | Roodepoort | 1 | 12 | B | |
Overall Recognition-Best in CVP Sales.xlsx
| ID | CealerCD | DealerName | Town | Region | Dist | Category | Best in CVP Sales |
| 1 | 1111 | Citrusdal | Citrusdal | 1 | 32 | E | |
| 2 | 0022 | Krugersdorp | Krugersdorp | 1 | 12 | B | |
| 3 | 1122 | Louis Trichardt | Louis Trichardt | 1 | 32 | D | |
| 4 | 1124 | Malmesbury | Malmesbury | 1 | 32 | E | |
| 5 | 1119 | Modimolle | Modimolle | 1 | 32 | E | |
| 6 | 1118 | Mokopane | Mokopane | 1 | 32 | D | |
| 7 | 9111 | Moorreesburg | Moorreesburg | 1 | 32 | E | |
| 8 | 9110 | North West | Lichtenburg | 1 | 32 | D | |
| 9 | 9110 | North West | Zeerust | 1 | 32 | D | |
| 10 | 9004 | Roodepoort | Roodepoort | 1 | 12 | B | |
Overall Recognition-Best in CVP Service.xlsx
| ID | CealerCD | DealerName | Town | Region | Dist | Category | Best in CVP Service |
| 1 | 1111 | Citrusdal | Citrusdal | 1 | 32 | E | |
| 2 | 0022 | Krugersdorp | Krugersdorp | 1 | 12 | B | |
| 3 | 1122 | Louis Trichardt | Louis Trichardt | 1 | 32 | D | |
| 4 | 1124 | Malmesbury | Malmesbury | 1 | 32 | E | |
| 5 | 1119 | Modimolle | Modimolle | 1 | 32 | E | |
| 6 | 1118 | Mokopane | Mokopane | 1 | 32 | D | |
| 7 | 9111 | Moorreesburg | Moorreesburg | 1 | 32 | E | |
| 8 | 9110 | North West | Lichtenburg | 1 | 32 | D | |
| 9 | 9110 | North West | Zeerust | 1 | 32 | D | |
| 10 | 9004 | Roodepoort | Roodepoort | 1 | 12 | B | |
and so on so forth....
refer to the inputs for details.
Thanks & Regards,
Chinmaya.
