Copying and pasting a formula

[whitesmarine]

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

[#2]

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.

[#3]

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.

[#4 · Accepted solution]

@whitesmarine 

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]

Thank you very much, I knew it was something simple

[#6]

You're welcome.