cell reference in a formula using 2 worksheets

O

Oxpictas

Need help in getting formula in a seperate worksheet same workbook to stay
the same when I change the master work sheet.

Example

'yearly data'!N5 cell changes to 'yearly data'!N6 when I insert a line in
the master work sheet 'yearly data' I want the "'yearly data'!N5" to be
permanant no matter how many lines I insert into the "Yearly Data" worksheet.

Please advise.
 
T

T. Valko

If you mean that the reference in a link/formula changes and you don't want
it to change:

=INDIRECT("'yearly data'!N5")
 
O

Oxpictas

Thank you, I think I understand it to mean I will need to put =INDIRECT in
every cell I want to stay without changing.
 

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

Combine information from two pages, two changing locations. 6
Formula for attendance record 8
How do I merge or combine 2 excel worksheets by a common collumn? 1
How do I link cells from a workbook, to talley one one sheet? 1
How to replace a cell's formula with a non-zero calculated value? 1
Pasting to calculated address 1
Reference cell values from other sheets in a function 2
Formula needed to create grand totals 1

Top