Loop to find data in a worksheet and copy into a different worksheet.

Hi Everyone,

So yet again my lack of VBA skills is causing me trouble, even though i'm very sure it's the quickest way to do what I want.

I have a workbbok with 8 sheets

sheet 1- 7 are for customers, and contain details of the date they used a certain product and the amount they used
sheet 8 is the price of the product on any given day since the beginning of 2010.

what I need is for code to look at the date a customer used a product and then find the corresponding price on that date.
And copy that price into the customers sheet. column 3
I need this to loop until the end of the customers data and then move on to customer 2 ... 3 .... etc

I have attached a sample of the workfile for reference.

Any help would be amazingly welcome.

Thanks.

Hi you could use this code to loop through all cells and return the values.
However i cant for the life of me remember why this does not work.
Its to do with you having tables.
if you done away with the tables and all ranges were formatted the same way then this should work.

your date formats are not the same between customer & price sheet that is also causing a problem.

Please Login or Register  to view this content.

Dates in excel are nightmare, least to say. I think the problem is still there. Sean's code should work if your dates match.