Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference in a formula using 2 worksheets
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference in a formula using 2 worksheets
If you mean that the reference in a link/formula changes and you don't want
it to change: =INDIRECT("'yearly data'!N5") -- Biff Microsoft Excel MVP "Oxpictas" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference in a formula using 2 worksheets
=INDIRECT("'yearly data'!N5")
-- Regards, Peo Sjoblom "Oxpictas" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference in a formula using 2 worksheets
Thank you, I think I understand it to mean I will need to put =INDIRECT in every cell I want to stay without changing. "T. Valko" wrote: If you mean that the reference in a link/formula changes and you don't want it to change: =INDIRECT("'yearly data'!N5") -- Biff Microsoft Excel MVP "Oxpictas" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference in a formula using 2 worksheets
Thank you
"Peo Sjoblom" wrote: =INDIRECT("'yearly data'!N5") -- Regards, Peo Sjoblom "Oxpictas" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell reference in a formula using 2 worksheets
I think I understand it to mean I will need to put =INDIRECT
in every cell I want to stay without changing. Yes, that's correct. -- Biff Microsoft Excel MVP "Oxpictas" wrote in message ... Thank you, I think I understand it to mean I will need to put =INDIRECT in every cell I want to stay without changing. "T. Valko" wrote: If you mean that the reference in a link/formula changes and you don't want it to change: =INDIRECT("'yearly data'!N5") -- Biff Microsoft Excel MVP "Oxpictas" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reference different worksheets in an autofill formula | Excel Discussion (Misc queries) | |||
formula reference between worksheets | Excel Worksheet Functions | |||
How do I reference the same cell, but in different worksheets? | Excel Worksheet Functions | |||
Cell reference between worksheets | Excel Worksheet Functions | |||
How do I copy a reference formula onto multiple worksheets | Excel Worksheet Functions |