Automatically Pulling Cells from Different Tabs and Files

B

bscuga

I want to have a formula that I can automatically pull cell c100 from tab 1,
tab 2, etc...from file 2 and pull cell d87 from tab 1, tab 2, etc... from
file #2. How do I automate this like when you create a regular formula using
the same tab and dragging and Excel populates the new cells with the new
formulas (for example: first formula is a1-b1, second formula is a2-b2). I
want the formula to automatically be like =[file 1]tab1!$c$100/1000 for
formula 1 and formula 2 to be =tab1!$d$87/1000. The second set of formulas
should be =[file 1]tab2!$c$100/1000 and =tab2!$d$87/1000. I want as I drag,
to have the tabs automatically change.

Does anyone know how?
 

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 paste the same cell one tab over 1
how to return an address from a lookup into a table? 8
Average Calculations 11
How do I reference one OR another worksheet? 2
Lookup value and return with all related data 0
Copying data from cells A1,B1,C1 on tab1 to tab2 1
Counting across tabs 1
Formula's in linking spreadsheets 1

Top