W
Worker Bee
I have a large workbook with many worksheets. Each Worksheet.Name is
unique, and contains a number, X. Each worksheet contains a 2-column
set of values, roughly like so:
A B
1 1
1 1
1 1
1 2
2 1
2 2
2 3
What I would like to create is a new table that correlates the unique
numerical values in the worksheet's name against the unique values in
that particular worksheet, so that I know which pairs of A's and B's
each worksheet contains. Something like:
A B C
X 1 1
X 1 2
X 2 1
X 2 2
Y (etc.)
Is this doable with formulae? I am thinking it may be necessary first
to manually insert a new column in each worksheet that contains that
worksheet's numerical name, to make the lookups easier.
Thanks much for any hints.
unique, and contains a number, X. Each worksheet contains a 2-column
set of values, roughly like so:
A B
1 1
1 1
1 1
1 2
2 1
2 2
2 3
What I would like to create is a new table that correlates the unique
numerical values in the worksheet's name against the unique values in
that particular worksheet, so that I know which pairs of A's and B's
each worksheet contains. Something like:
A B C
X 1 1
X 1 2
X 2 1
X 2 2
Y (etc.)
Is this doable with formulae? I am thinking it may be necessary first
to manually insert a new column in each worksheet that contains that
worksheet's numerical name, to make the lookups easier.
Thanks much for any hints.