Cell coordinates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. Vandenberg - 30 Jul 2004 07:11 GMT

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

Reply to this Message

Otto Moehrbach - 31 Jul 2004 17:55 GMT

J
You will need VBA for such a task. The code will have to have a means
of distinguishing the end of one table and the beginning of another. What
is that?
Also, you say that the heading and item row will appear more than once
because there are multiple tables. You say you want to accomplish this
search for the "nth" instance. Do you mean that you want to specify the
value of "n" and find only that one instance? Or do you mean that you want
to have as many responses as there are instances? HTH Otto

> 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
[quoted text clipped - 12 lines]
> Any help would be appreciated.
> -Joel

Reply to this Message