Copy range and past on another sheet

[gumby]

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

 

[Vasant Nanavati]

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]

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)

________________________________________________________________________








- Show quoted text -

Works good, but I need it to paste as values and not just copy.

 

[Vasant Nanavati]

Then:

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