ok, sorry!!

in column C i will have have initials of 1 of 3 different managers.
in columns G - L there will be different dollar amounts (for different
options sold). In this main workbook there are 16 different sheets for
different depts.

i need to link another workbook to this main workbook that will return
the amounts in columns G through L each time it sees a certain set of
initials in column C. Is that a little more clear foor you?? :)


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=482879