Sort and Move Data to Multiple Worksheets

[The Doctor]

I'm trying to automate weekly expense reports a little more. I have a large list of credit card transactions,and using a Vlookup match Credit Card numbers with Employee names. I would like a VBA or Macro to sort the list by names, then copy each employees name into their own workbook, or worksheet which can be sent to them once a week. The columns are:

Trans Post Description Number Amount Name of Cardholder


I need the name of cardholder to be the column used to sort out who gets which credit card data.


All help is appreciated.


Thanks,

The_Doctor

 

[Hui]

The Dr


You may want to have a look here: http://chandoo.org/wp/2012/11/27/extract-subset-of-data/

 

[kchiba]

Hi Doctor,


You can achieve all this by with a PIVOT table.


cheers


kanti

 

[The Doctor]

Thanks Hui, I didn't see that one when I searched the site for the solution.