Hi,

I am stumped. I am not good at writing macros(but I am learning).
Here is my situation. I have 2 tables. One table is a summary, while
table 2 shows the specifics of the items in table one.

Once someone types an ID # into table one it immediately populates
table 2 with 18 rows (that all have the exact same ID #).

If someone creates another entry another 18 rows are populated.

What I am trying to do is on the 2nd worksheet link the top cell and
pull down 17 more cells(then vlookup the figures). The problem is if
I have 500 entries, i have to create the top cell and pull down 17
cells 500!!! times.

Is there an easy way to do this?

Thanks,

John