You would need a macro to do this.

Sheet1.Range("B1:C3").Copy Sheet2.Cells.Find(Format(Sheet1.Range("A1"),
"h:mm AM/PM")).Offset(1)

__________________________________________________ ______________________


"gumby" wrote in message
oups.com...
I need to copy a range from sheet 1 to sheet2 and copy it directly
below a cell that eqauls a cell value on sheet1.

So if Sheet1 Cell A1 equaled 7:00 AM I would want the range copied to
sheet2 directly below the Cell with a value of 7:00 AM in it.


Thanks - David