Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference to cells using autofilter problem
Hello,
my problem seems pretty simple. Let's say I have a sheet with 3 columns: first name, last name and age. I enable the "autofilter" function to decide if I want to sort by first name or last name. Somewhere on another sheet I make a reference to someone's age. Let's say that I point to Bill on row 3 so his age is in cell C3. If on another sheet I make a reference to C3 (for bill's age) but then I use the autofilters to change the sort... the other sheet still refers to C3 instead of being updated with Bill's new cell for his age. I just realised that when I use the SORT function, it still does the same thing... the reference doesn't get updated if I resort.. How do I do this?? Am I missing something? I of course want to have the cross-sheet references updated when resorting! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Array, circular reference problem | Excel Worksheet Functions | |||
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) |