Sorry - yep, there are 12 columns involved each containing differen
info such as stock, cost price, market price, product name etc. O
these 12 the only criteria is in column L. Column L contains differin
dates for when a product arrived. The only info that needs to be copie
are those pertaining to today() (which is in cell A1.)

e.g

PRODUCT PRICE STOCK DATE
APPLE 1.50 15 01/09/05
BANANA 2.00 0 31/08/05
CRANBERRY 1.20 55 24/08/05
DILL 3.50 10 01/09/05

So in this example, assuming todays date (note there would be 8 mor
columns in the middle) only the info for APPLE and DILL would b
transferred over to the other worksheet. BANANA and CRANBERRY woul
already have been transferred on the 31/08 nad 24/08 respectively.

Let me explain what this is all for....

This forms part of a stock check and pricing system for a greengrocers
Products come in, checked against bills and an invoice produced. Thi
part of the system above will archive any purchases made so that ol
bills could be checked. The reason i have to transfer over todays(
info is so that the next day when a new item comes in, it forms th
basis of the new price list. Hope that explains all this. I'm tryin
to learn VBA but at the moment i'm just piecing together the syste
with help from you guys (and gals). Who would have thought there wa
so much to selling a pound of spuds....

--
chris10
-----------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...fo&userid=2516
View this thread: http://www.excelforum.com/showthread.php?threadid=39971