Forum Discussion
Solved
Copying and pasting a formula
I have the following that I am copying and pasting, however when I paste it copies it exactly. I would like for the last number to increase by one every time I paste, is this possible? ='https://...
If you're looking to pull A41, A42, A43, etc. then you'll need to remove the absolute referencing:
='https://d.docs.live.net/6dec2f982c92d91e/Desktop/NEW PRICING CALCULATOR/[PriceUpdateFile.xlsx]MB167665_202207030211550581692'!A41
If you're looking to pull A41, A42, A43, etc. then you'll need to remove the absolute referencing:
='https://d.docs.live.net/6dec2f982c92d91e/Desktop/NEW PRICING CALCULATOR/[PriceUpdateFile.xlsx]MB167665_202207030211550581692'!A41- Thank you very much, I knew it was something simple
- You're welcome.
