In the same workbook-
(1) Row 1 of sheetX contains various field names
(2) Column 1 of sheetX contains various city names

and

(3) Row 1 of sheetY contains various field names including the field
names in sheetX
(4) Column 1 of sheetY contains various city names including the city
names in sheetX.

-- I need a macro that will do this:
For each city in Column 1 of sheetX, find the same city in
column 1 of sheetY. Then, for all the data in the fields for this city,
link them to the corresponding data fields for the corresponding city in
SheetY.
I would greatly appreciate this. I really need help!

Thanks.
Jay Dean

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!