update data by looking invoice number

Hi,

I need a formula OR VBA Code

I am working on two different worksheets. In both worksheets I have 5 columns " Date" , " Customer Name" , "Invoice number", "payment Received", "Amount Receivable".

I want when in my main worksheet #1 when any Payment is received for a particular invoice . The data of only column "Payment Received" should be automatically update to second sheet row by looking/searching that particular " invoice number " .

Any formula or VBA please

Plz Help..

Thanks

exactly that whats I am looking
please submit code

Hello xladept

Hi Thanks very much for your help.. this really works for me

Can you tell me what If my I also want update another column using the same invoice number..I mean what I want to update two columns using the same invoice number.........like column number 4 and cloumn 5.

Can you please send code for multi column update using same invoice number
Thanks once again


Regards
Z