View Single Post
  #1   Report Post  
weeshie73
 
Posts: n/a
Default Update worksheet by comparing two cells


Hi All,

I'm struggling with a solution and hope you can help.

I have two worksheets, Local and Master, where both are set up as
follows:

A1: UniqueID A2: Acct# A3: LocationCode

I want to update my Master WS with the UniqueID from the Local WS,
matching on Acct# and LocationCode. Can this be done by a formula or
is a macro necessary?

Thanks in advance!
Christine


--
weeshie73
------------------------------------------------------------------------
weeshie73's Profile: http://www.excelforum.com/member.php...o&userid=24792
View this thread: http://www.excelforum.com/showthread...hreadid=398631