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??