| 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. |
| 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 | |||
Threaded Mode
