Forum Discussion
See for example Create workbooks from unique values in column A
Modify the code to suit your situation.
I download our credit card charges each month for 20 different people into one worksheet. I need to separate the data into individual workbooks to be sent to my employees for itemizing. I know there has to be an easier way of doing this than copy and paste! I was hoping someone could help me. I have watched many videos and learned a lot of different tricks, but none that will help with this particular project that I have to accomplish each month. Any advise??
Thanks,
Rita
See for example Create workbooks from unique values in column A
Modify the code to suit your situation.