Hi Guys,

Not sure if this is possible but in my attached sheet I have 1 sheet (sheet 1 "fruit") of customers buying fruit, 1 sheet (Sheet 2 "Veg") of customers buying veg, and a summary sheet of them both (Sheet 3) In an attempt to save time & prevent double inputting I was looking for some code that would allow me update the third sheet automatically when first or second sheet is up dated. So basically the code I need in English is
"if column F (sheet 1 Fruit) is not blank, then look for Column B in Sheet 1 and match with column B in Sheet 3 and change column D to Paid and make column E Sheet 3 equal column F Sheet 1
also
if column F (sheet 2 Veg) is not blank, then look for Column B in Sheet 2 and match with column B in Sheet 3 and change column D (Sheet 3) to Paid and make column E (Sheet 3) equal column F Sheet 1"
Hope you can make sense of it.
Thanks in advance
Attachment 437355Book1.xls