| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to select a row and insert a copy later in the worksheet
Please is there an easier way of copying a row with formulae containing
relative rows and insert the row elsewhere in the document -- Thanks Dennis |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to select a row and insert a copy later in the worksheet
Easier as opposed to what, what's wrong with copy and paste?
If you want to get the same cell references don't use relative references, use absolute or do an edit replace, replace the equal sign with something like ^^ or $$$$$, copy the row, paste it somewhere else, then reverse the editreplace and replace ^^ with = -- Regards, Peo Sjoblom "Dennis Milns" wrote in message ... Please is there an easier way of copying a row with formulae containing relative rows and insert the row elsewhere in the document -- Thanks Dennis |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to select a row and insert a copy later in the workshee
I do want relative addressing as the copied row is a formula template - now I
am doing the selectrow copy selectrow insert about 100 times per session..... -- Thanks Dennis "Peo Sjoblom" wrote: Easier as opposed to what, what's wrong with copy and paste? If you want to get the same cell references don't use relative references, use absolute or do an edit replace, replace the equal sign with something like ^^ or $$$$$, copy the row, paste it somewhere else, then reverse the editreplace and replace ^^ with = -- Regards, Peo Sjoblom "Dennis Milns" wrote in message ... Please is there an easier way of copying a row with formulae containing relative rows and insert the row elsewhere in the document -- Thanks Dennis |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to select a row and insert a copy later in the workshee
Post one of your formulas with cell-referencing you want to remain "relative"
and from where will you copy it and to where? Gord Dibben MS Excel MVP On Mon, 25 Jun 2007 16:18:00 -0700, Dennis Milns wrote: I do want relative addressing as the copied row is a formula template - now I am doing the selectrow copy selectrow insert about 100 times per session..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| Can insert W/S but not copy a worksheet | Excel Worksheet Functions | |||
| Want macro to select & copy cells from a different worksheet | Excel Discussion (Misc queries) | |||
| Smart use of .Activate; .Select; .Copy with Sheets(1) va Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
