sounds like you need to do a VLOOKUP in column A to populate cell J2 in
the remaining sheets.
This will only work if column A is sorted alphabetically.

otherwise could you do a MATCH within an INDEX to find the data.


--
carstowal
------------------------------------------------------------------------
carstowal's Profile: http://www.excelforum.com/member.php...o&userid=37476
View this thread: http://www.excelforum.com/showthread...hreadid=571844