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
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?
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:
- Formula with varying information need pasted multiple times
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
- Times attack - Download - Children
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
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