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!