Can I pull data from a spreadsheet to another spreadsheet

P

Pat

I download a spreadsheet with corporate credit card charges and copy and
paste each individuals credit card charges to a worksheet for each person
because I need a running total on each persons charges. Would there be any
way to automate this?

Thanks for any suggestions!
 
D

Don Guillett

If we are to assume that they are mixed up, you could use
data>filter>autofilter to filter by name and then copy/paste. Of course,
this could even be automated with a for each loop on a list with each name.
 
Top