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
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.
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.
