Hello,

I have multple sheets.

Sheet A with
Name, Dept#,Phone,Manager
John Doe, 1105, 123-123-1234, blank

Sheet B with
Dept#,Manager
1105, Mgr John Doe
1123, Mgr Jane Doe

I am to
for each row in sheet a
match a row in sheet b based on the dept#
insert into the manager cell of sheet a with the value from manager
cell sheet b

Any direction would be great. Thanks.


--
JeffH
------------------------------------------------------------------------
JeffH's Profile: http://www.excelforum.com/member.php...o&userid=36866
View this thread: http://www.excelforum.com/showthread...hreadid=565861