Hi,
I want to be able to write all rows that have the same number in column A to another sheet and save that sheet as multiple.xls and then return to the first sheet and delete those rows that have been moved and then save that sheet as single.xls
I have attached the example file which shows the original data in the StartingFile tab and then the required output files in the form of the other 2 tabs.
Thanks for any help,
David
Bookmarks