J
J. Vandenberg
I have an imported sheet that has a ton of data on it.
I want to have my worksheet find data on the imported sheet by
heading.
So, for example, I want the data from the cell in the column labeled
'sales total' and from the row 'cd players' the catch is that heading
isn't always in the same spot on the imported sheet and the sheet may
have multiple tables, one above the other on down with the same
headings in different columns. So I need either formula or VBA code
that either returns the cell's value or at least the address. Because
there are multiple tables I also need a way to do this for the nth
instance. I've been messing with lookups but the column can change so
that didn't really work out.
Any help would be appreciated.
-Joel
I want to have my worksheet find data on the imported sheet by
heading.
So, for example, I want the data from the cell in the column labeled
'sales total' and from the row 'cd players' the catch is that heading
isn't always in the same spot on the imported sheet and the sheet may
have multiple tables, one above the other on down with the same
headings in different columns. So I need either formula or VBA code
that either returns the cell's value or at least the address. Because
there are multiple tables I also need a way to do this for the nth
instance. I've been messing with lookups but the column can change so
that didn't really work out.
Any help would be appreciated.
-Joel