Can I pull data from a spreadsheet to another spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
You must log in or register to reply here.

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

matching a column of numbers to another in another spreadsheet 1
how do I test for a text value in cell c1, if it is there, make c. 1
How do I track credit card debt on one spreadsheet? 1
I need an answer display in one cell if (=), but another if (-) 3
Transfering data from one spreadsheet to another. 3
I can't figure out how to add values based on font color. 1
merging spreadsheet data 1
Lookups - how to obtain data from a master spreadsheet into another 5

Back
Top