Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference entire worksheet in new worksheet
Hi - I would like to reference an entire worksheet from a new worksheet.
Once I do that, I can sort and create different views without changing the original worksheet. My thinking is that whenever I change a cell in the referred to worksheet it will automaticall change in the new worksheet even though it is sorted. It this correct? Any help would be appreciated - Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary worksheet reference to detail worksheet | New Users to Excel | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions |