Page 2 of 2

Copy without relative formulas changing

murphyobrien@gmail.com

Guest

Posts: n/a

15th May 2006

Ron Coderre wrote:

> Since you are inclined to replace = in the formula with a character, perhaps
> this:
>
> Using your posted example:
>
> Select A1:A3
> <edit><insert><row>
> (that pushes everything down 3 rows)
>
> Copy B4:B6 to B1:B3
> Move B1:B3 to C1:C3
>
> Copy A4:B6 up to A1:B3
> Clear the contents of A4:B6
>
> Is that something you can work with?
>
> ***********
> Regards,
> Ron

Yes, that works. I'l try to remember it next time.

Murphy

Page 2 of 2

« changing hyperlinks | Manually Calculating Formulas - Resetting totals to zero »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do i copy values between tables using relative formulas	ther00k	Microsoft Excel Misc	1	21st Dec 2007 09:23 AM
How to copy an array without changing relative cell refferences?	Dmitry	Microsoft Excel Discussion	12	20th Jun 2006 02:07 PM
How to copy an array without changing relative cell references?	Dmitry	Microsoft Excel Discussion	0	19th Jun 2006 03:08 PM
Changing formulas from relative to absolute	=?Utf-8?B?QXhlbA==?=	Microsoft Excel Misc	4	14th Jun 2006 09:13 PM
Changing the way relative references in formulas are adjusted when copied	Jana L.	Microsoft Excel Misc	0	22nd Sep 2003 05:22 PM