Large Excel spreadsheet separated into multiple worksheets via data in 1 column

Copper Contributor

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



1 Reply