is anyone familiar with the pull formula in excel?

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

Guest

I have multiple workbooks and i need to create a summary sheet that can pull
information from all the other workbooks. the cells that i need to pull are
the same on each of those and i know there is a pull formula that would make
this easy for me but i'm not sure how it works. otherwise i'd have to go in
and manually input each of the cells that i need into the summary and that is
very time consuming.

Please help if you can.
 
The easiest way is to open both files; in the target file cell type =, now
point at the cell in the source file cell. This gives a formula in the form
='[Travel Apr 07.XLS]April'!$B$4 where the file name is within [ ] , and
April happens to be the name of the sheet in the source file.
If you need to copy this formula down a column you will need to remove the $
signs that make it absolute
best wishes
 
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

How to Auto Reference Worksheet Tab ID's in Formulas? 9
Reference the same cell based on tab name 1
Pulling data from Sheets in A workbook 2
If formula based on cell formats 1
Summing multiple validated sheets into a summary sheet 3
SUM function on multiple worksheet 5
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Sum formula across multiple tabs and fields 2

Back
Top