Extract data from tables and populate a separate table?

[Mirisage]

Hi Forum,

I wanted to extract data from "Miami" and "New York" tables and populate the "Miami + New York" table.
Would there be any automated way of doing this such as vlookup because I have several hundreds of records in each "Miami" and "New York" tables.? ?
Thanks

Mirisa

[Moo the Dog]

You could use this in C6:

Please Login or Register  to view this content.

Then fill that right to column H, then down to your last row.

- Moo