Hi...I am looking for someone to help me on this problem of mine...I am running a small business of timber and plywood and I usually record my daily sales in a workbook which has a main sheet for recording daily sales [having multiple columns] and some other sheets for particular customer credit a/cs....I want the customers credit info from the daily sales sheet to get entered in the customer's respective worksheet automatically....I have tried to use advance filter but that does not add the data automatically everytime I update the daily sales sheet..My daily sales worksheet look a bit like this

Date cash/credit CustomerName Item Qnty[in cft] Rate[per cft] Amount
03/10/2011 credit xyz 4x1.5 2.0355 100 203.55
03/10/2011 cash cash 5x1.25 1.0000 200 200.00
03/10/2011 credit abc 3x1.5 3.0000 300 900.00

and so on.......and my cust a/c worksheet have columns like this...
Date Item Qnty[in cft] Rate[per cft] Amount


Here xyz and abc are customers name with whose names i have a worksheets and i want their respective entries to get copied in their particular worksheets whereas i don't want the cash sales to get entered anywhere else...

Can anyone help me with this please.....????