Report

Formula with varying information need pasted multiple times

Ask a question huestis 1Posts Thursday October 5, 2017Registration date October 5, 2017 Last seen - Last answered on Oct 5, 2017 at 10:43 PM by ac3mark
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?


Helpful
+0
plus moins
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".

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!