M
MPH
Hope someone can help with this - I'm stumped.
I have a 3D named range referring to 5 different file pages.
The range in each page is the same shape and each column header is unique
text and the range refers to the data under the header.
The 1st column of each table contains a unique value in sequential order -
25 follows 24 etc.
All other columns contain text or a value; some values are the result of a
formula.
The list in each page is 50 cells long.
In another page, I want to list all of the entries in the 3D range, in
ascending order according to the first column in the range i.e. 1,2,3 etc.
Vlookup doesn't work and I can't figure out what else to use.
Hope I have explained the above so it can be understood.
Will appreciate any help.
Thanks in anticipation
Malcolm Hughes
I have a 3D named range referring to 5 different file pages.
The range in each page is the same shape and each column header is unique
text and the range refers to the data under the header.
The 1st column of each table contains a unique value in sequential order -
25 follows 24 etc.
All other columns contain text or a value; some values are the result of a
formula.
The list in each page is 50 cells long.
In another page, I want to list all of the entries in the 3D range, in
ascending order according to the first column in the range i.e. 1,2,3 etc.
Vlookup doesn't work and I can't figure out what else to use.
Hope I have explained the above so it can be understood.
Will appreciate any help.
Thanks in anticipation
Malcolm Hughes