Formula with varying information need pasted multiple times [Closed]

Report
Posts
1
Registration date
Thursday October 5, 2017
Status
Member
Last seen
October 5, 2017
-
 Blocked Profile -
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?


1 reply

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!