| View previous topic :: View next topic |
| Author |
Message |
CalcBeginner
General User
Joined: 29 Feb 2012
Posts: 11
|
 Posted: Wed May 02, 2012 8:06 pm Post subject: How to copy formula in one cell to another, relative? |
 |
|
Is there a way to copy a relative formula from one cell to another cell that is not contiguous?
Thanks for any pointers. |
|
| Back to top |
|
 |
pitonyak
Administrator
Joined: 09 Mar 2004
Posts: 3618
Location: Columbus, Ohio, USA
|
| Posted: Wed May 02, 2012 8:16 pm Post subject: |
|
|
My guess is that I do not understand your question.
In cell B2, enter the formula =D5
Now, copy cell B2 to the clipboard and paste it at C5. I expect that the formula will now be E8. Is this not correct?
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php |
|
| Back to top |
|
|
CalcBeginner
General User
Joined: 29 Feb 2012
Posts: 11
|
| Posted: Thu May 03, 2012 4:25 am Post subject: |
|
|
You're right. That does work. I have no idea why I couldn't figure that out myself.
Thanks for the answer! |
|
| Back to top |
|
|
pitonyak
Administrator
Joined: 09 Mar 2004
Posts: 3618
Location: Columbus, Ohio, USA
|
|
| Back to top |
|
|
|
