How to refer to columns in repeating groups

  • Thread starter Thread starter Andrew Malcolmson
  • Start date Start date
A

Andrew Malcolmson

I have a database-like worksheet with a header layout like so:

itemID firstName lastName phone firstName lastName phone ...
--------------------------------------------------------

I have 30 sets of 3 field 'items', which is a lot, so I'd like the
convenience of refering to all of the columns of the same type (in
this case, every third column) in an expression, e.g.

phoneNumbers=(array of the values of the phone fields in this row)

Ideas?
 
Hi!

I'm using excel2000 (which might be important).

I don't know what you want to do with the columns but you can selec
them, give them a name and thereafter refer to the as an "item".

For example:

select col 4 (col D, if you like); hold down ctrl and select col 7
still with ctrl held, select col 10 ....

Then Insert|Name|define and call it, say, Phones.

You don't have to select the whole column, of course: perhaps just th
used or usable part?

If you now click on Phones in the Name Box, your selection will b
highlighted, so you can colour it, edit it or whatever, including usin
it VBA subs. Handy if they change the phone number format -- again.

Al
 
Back
Top