Copy range and past on another sheet
 

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

Copy range and past on another sheet
 

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

Copy range and past on another sheet
 

On Jul 16, 8:29 pm, "Vasant Nanavati" <vasantn AT aol DOT com wrote:
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- Hide quoted text -

- Show quoted text -

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

Copy range and past on another sheet
 

Then:

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

"gumby" wrote in message
oups.com...
On Jul 16, 8:29 pm, "Vasant Nanavati" <vasantn AT aol DOT com wrote:
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- Hide quoted text -

- Show quoted text -

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