Thanks for the reply Christen. I wound up using a VLOOKUP which seems
to pull the information correctly. The only problem is that it still
involves manually inserting rows between the different blocks(employee
specific) of data from tab 2 so that the spacing matches the spacing on
tab 1. I need that so that formulas I am using in tab 1 that reference
the data work correctly. Not sure if this can be automated in the
formula or not.
Thanks again.
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=274201