JLGWhiz wrote:
Where is the date located on sheet two with respect to the data that was
copied from sheet one and what column and row does the data in sheet three
reside that you need the sheet two data copied adjacent to? Examples would
help a lot.

I have a wookbook containing three wooksheets, imformation is entered on
sheet 1 and copied to sheet two automatically, this is where my trouble
[quoted text clipped - 3 lines]

I hope this is clear, and thanks in advance for any and all help.
the date is in cell I7 on sheet 2. sheet 3 is as below
total # # of lifts # of lifts
date cycles <50% 50%
15/10/2006 (i need to find the date on sheet 3 that match es the date on
sheet 2 and copy the
16/10/2006 data from Range ($AA$15:$AF:$15) on sheet2 into the range
adjacent to the appropiate date)

--
Message posted via http://www.officekb.com