Greetings!
I have a report with " x" rows, " y " columns.
I want by an input box to select " n" rows to be copied each row in the report and paste the values in specific cells in an existing Excel template file.
ie:
| A | | B | | C | | D | | E |
| 1 | |Name| | Address| | email| | phone| | City |
|Source file | | Destination Workbook ( Template)|
|A1| |B3|
|B1| |A3|
|C1| |K3|
|D1| |C3|
|E1| |D3|
Each row in the report should be pasted into a new file ( same template)without overwriting
It is possible to duplicate the same file ( template) for each row in the report??
Any support would be REALLY appreciated!
Thanks!
Bookmarks