Hi everyone
Sorry if this question has been asked a million times, but I need a macro to separate one spreadsheet into multiple spreadsheets based on the name in column A
I then need the spreadsheet to be named whatever is in column A.
I got this working fine with a filter macro, but apparently the last time this was used, it omitted data because the spreadsheet is very large and so a looping macro would work better.
It also needs a failsafe mechanism which will check that the correct file was made with the correct entries.
Can anyone help?
Thank you!
Sorry if this question has been asked a million times, but I need a macro to separate one spreadsheet into multiple spreadsheets based on the name in column A
I then need the spreadsheet to be named whatever is in column A.
I got this working fine with a filter macro, but apparently the last time this was used, it omitted data because the spreadsheet is very large and so a looping macro would work better.
It also needs a failsafe mechanism which will check that the correct file was made with the correct entries.
Can anyone help?
Thank you!