I have the following issue. For each occurence of a name in an excel file i need to create seperate excel files and paste the rows. The problem is that the number of ofcurrences and the rows of the datatable are therefore not fixed.
How can i create a dynamic approach to this (please see attached for an example excel file). the idea is that two files are created called John and Max in this case and that the rows corresponding with their names are copy and pasted in teh file. Ideally, the “blank row” (i.e. the row not containing a name) needs to be added to the name above. Also i would like this to be in a datatable as i want to use append range (since 1 name can occur multiple times).
Thank you in advance.
Matthewtraining.xlsx (8.6 KB)