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://d.docs.live.net/6dec2f982c92d91e/Desktop/NEW PRICING CALCULATOR/[PriceUpdateFile.xlsx]MB167665_202207030211550581692'!$A$41
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
5 Replies
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.
- The link you provide is broken so we can't see the file you're referring to.
That said, copying and pasting is exactly that, and it pastes what you're copying, not a variation on it, no matter how banal.
So let's back up and get a more complete picture. There pretty surely is another way to increment a value by one even though copy/paste ain't it. Seeing the file--after you fix the link--will help us help you.- It is a file on my desktop, not sure I can make it accessible to you. It is just pulling data from a cell on another excel file.
