How do I pull information from multiple existing spreadsheets int.

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

Guest

I need to pull information from multiple spreadsheets into a new spreadsheet
to develop a monthly recap.
 
Maybe using formulas that point at the specific cells you want brought back???
 
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 said:
I need to pull information from multiple spreadsheets into a new spreadsheet
to develop a monthly recap.
Click to expand...

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
 
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

hide rows if nil result of formula in specific column 2
Excel shortcut options 0
Pull Data from multiple sheets 1
Pulling a specific email from cells and putting info in new row 4
Pulling out comments with macro 4
How do I pull data from multi sheets into one? 2
Lookup value from one sheet & show value in corresponding row of current sheet 1
Index/match across multiple columns? 19

Back
Top