Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell References
I have about 116 worksheets in a workbook. The first
sheet (called MACRO_INTERFACE) has a list of report names on it and the remaining worksheets have data for those reports. Each sheets has a cell reference to the main sheet to show the name of the report listed on the main sheet (looks like =MACRO_INTERFACE!B6) The problem I am having is that every time I sort the list on the main sheet, the references change and I get the wrong report names shown on the sheets. How can I keep the cell references from changing when I do a sort? ~Jenny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find #ref! invalid cell references within cell formula | Excel Worksheet Functions | |||
Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) | Excel Discussion (Misc queries) | |||
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) | Excel Worksheet Functions | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) |