point to one number on each sheet that will be in many formulas

G

Guest

I have many worksheets in one file. I have formulas on each sheet that point
to data on the first summary sheet. The only change is which line number to
get data from. I want to have one cell on each sheet with the corresponding
line number from the summary sheet, and have all the formulas on each sheet
combine or point or whatever it takes to do it - to that line number.
 
G

Guest

=INDIRECT(ADDRESS(A2,2,,,"Sheet1")) will return the value on Sheet1 in column
2 and the row specified by the value in cell A2. If you want to keep blanks
from turning into 0's, you could embed that inside a test for isblank
=IF(ISBLANK(INDIRECT(ADDRESS(A2,2,,,"Sheet1"))),"",INDIRECT(ADDRESS(A8,2,,,"Sheet1")))
Either way, change the cell reference to pick up different rows, and the
column number to pick up different columns.
HTH. --Bruce
 

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

Count the columns from one sheet and paste it in another sheet 0
Countif with indirect formulas needed 0
Excel A CountIF question... I think 2
Recalc of SUM() that refers to a cell across a range of worksheets 4
copying formulas from worksheets 3
Copying Selective Data Between Worksheets 5
Excel Move or Copy Stopped Working? 0
Adding numbers from sheet 2 to sheet 1 2

Top