Formula with varying information need pasted multiple times [Closed]

Question

Formula with varying information need pasted multiple times [Closed]

Report

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?

Formula with varying information need pasted multiple times
How to copy and paste multiple times in excel vba - Forum - Excel
VBA code for copy & paste items for multiple times ✓ - Forum - Excel
VBA Code to Copy Worksheet multiple times and rename based on list ✓ - Forum - Excel
Copy row and insert n times ✓ - Forum - Office Software
Copy data and pasting multiple times using macro - Forum - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2017-10-05T22:43:22-0400

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

Formula with varying information need pasted multiple times [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!