Example data.xlsxCan someone help me with a good VBA-code for underlying problem?
I have to save a lot of excel-files with different names. (about 100)
I need a macro to automatically save excel-files with different names in a specific folder on my computer.
See attachment.
The name of the files should contain the combination of column G and H. (for example "1206 - Praktijkhuisman.xlsx")
He should make a new file when there is an other unique value in Column G.
After making a new excelfile he should copy the data (include layout) in a tab (with same name as the new excel file) from column A t/m L.
Only the data for the Unique value in Column G.
Please can someone help me??
Bookmarks