ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   3-D referencing (https://www.excelbanter.com/excel-discussion-misc-queries/43837-3-d-referencing.html)

YBeaupre

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.


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com