Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I pull information from multiple existing spreadsheets int.
I need to pull information from multiple spreadsheets into a new spreadsheet
to develop a monthly recap. |
#2
|
|||
|
|||
Maybe using formulas that point at the specific cells you want brought back???
JJohn wrote: I need to pull information from multiple spreadsheets into a new spreadsheet to develop a monthly recap. -- Dave Peterson |
#3
|
|||
|
|||
Do it the same way you reference cells on the same worksheet. In Sheet1, a
reference to cell A1 on Sheet2, will look like Sheet2!A1. "JJohn" wrote: I need to pull information from multiple spreadsheets into a new spreadsheet to develop a monthly recap. |
#4
|
|||
|
|||
"JJohn" wrote in message ... I need to pull information from multiple spreadsheets into a new spreadsheet to develop a monthly recap. I have helped someone else with a macro that does this. More information would be helpful. How are these files organized? Is there a naming convention? What program generates them? Do you need single values or do you want the sum of several cells? /Fredrik |
#5
|
|||
|
|||
Hi John
I have some examples on my site Copy examples and formulas http://www.rondebruin.nl/tips.htm -- Regards Ron de Bruin http://www.rondebruin.nl "JJohn" wrote in message ... I need to pull information from multiple spreadsheets into a new spreadsheet to develop a monthly recap. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Return Multiple Results with Lookup | Excel Worksheet Functions | |||
Using multiple spreadsheet for different information | Setting up and Configuration of Excel | |||
How do I pull in multiple data sets at once? | Excel Discussion (Misc queries) |