I have used VBA to ease up my reporting. I download data from our central database and then create worksheets for the end-users (The reports from the central database do not give the field users the info they need)
So to my question........
Each of my records has 1 of 7 names associated with it. All of the data needs to copied to it's own worksheet, so that each of the names has a detail sheet.
Currently my code auto-filters the data on the main worksheet and copies the filtered data to the right worksheet. (All of John Doe's records go onto the John Doe sheet)
This is really slow. It takes along time for my code to run.
I am sure this isn't the most efficient way to do this. All I need is to copy the rows of data that have John Doe in column A to the John Doe sheet.
Can someone point me in the right direction?