Formula with varying information need pasted multiple times

huestis 1 Posts Thursday October 5, 2017Registration date October 5, 2017 Last seen - Oct 5, 2017 at 01:40 PM - Latest reply: ac3mark 9999 Posts Monday June 3, 2013Registration dateModeratorStatus July 20, 2018 Last seen
- Oct 5, 2017 at 10:43 PM
Hello,

I have what may be a simple issue. I have a spreadsheet that I need to apply a formula to in certain fields. One formula may need to be =Y3-V2 but then further down it may need to change to =Y19-V15, see the difference in cell count? Is there a macro that will save me from having to manually input the varying formulas?


See more 

Your reply

1 reply

ac3mark 9999 Posts Monday June 3, 2013Registration dateModeratorStatus July 20, 2018 Last seen - Updated by ac3mark on 5/10/17 at 10:44 PM
0
Thank you
Does this help out with what you are tyring to do?

https://support.office.com/en-us/article/Switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9

Have fun!

P.S. It is "relative".

It's kind of fun to do the impossible! -Walter Elias Disney
Respond to ac3mark