Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull data from a spreadsheet to another spreadsheet
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull data from a spreadsheet to another spreadsheet
If we are to assume that they are mixed up, you could use
datafilterautofilter 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. -- Don Guillett SalesAid Software "Pat" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I pull data from a spreadsheet to another spreadsheet
You could sort, then use the data/subtotals feature.
"Pat" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
scan a document and pull into excel spreadsheet to edit | Excel Worksheet Functions | |||
VBA to Pull info from 2 diff tabs from the same spreadsheet | Excel Discussion (Misc queries) | |||
how do i pull all subtotals from a spreadsheet | Excel Worksheet Functions | |||
Pull down cell to access n&a spreadsheet | Excel Worksheet Functions |