| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro: Insert, copy and past data from sheet | Excel Discussion (Misc queries) | |||
| select a range, copy it to a new sheet | Excel Discussion (Misc queries) | |||
| Copy and Past | Excel Discussion (Misc queries) | |||
| copy & past in same format | Excel Discussion (Misc queries) | |||
| auto copy and past | New Users to Excel | |||
Linear Mode
