Copy range and past on another sheet

  • Thread starter Thread starter gumby
  • Start date Start date
G

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
 
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)

________________________________________________________________________
 
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 -
Click to expand...

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

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