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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I track credit card debt on one spreadsheet? 1
Re-title multiple MS Project .mpp files at once 0
Linking data in MS Word into Excel 5
Creating a Chart on form from selected data in query. 0
matching a column of numbers to another in another spreadsheet 1
Protection of Data 3
I can't figure out how to add values based on font color. 1
Transfering data from one spreadsheet to another. 3

Top