Formula with varying information need pasted multiple times

Closed
huestis Posts 1 Registration date Thursday October 5, 2017 Status Member Last seen October 5, 2017 - Oct 5, 2017 at 01:40 PM
 Blocked Profile - 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?


Related:

1 response

Does this help out with what you are tyring to do?

https://support.microsoft.com/en-us/office/switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9?ui=en-us&rs=en-us&ad=us

Have fun!

P.S. It is "relative".

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