Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3-D referencing
Can you provide me with an exemple or a link that will show me how to perform
3-D references in Excel. From sheet-1, I wish to edit data that will automaticly reflect on sheet-2 & sheet-3. Sheets 2 & 3 are copies of data on sheet 1 where my cells are sorted in two differents ways, i.e. Sheet one = Sort on column A & B, Sheet two = Sort on column H, A & B, Sheet three = Sort on column E, A & B. I know how to sort data from within a sheet. I do not know and/or understand from the help tool, how to 3-d reference the same data sorted in different ways on two separate sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing lines and series points | Charts and Charting in Excel | |||
How do I turn off relative cell referencing in excel? | New Users to Excel | |||
How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
Functions referencing unopened workbooks | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions |