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