how can I increment a file name when I copy a formula to the cell below

[peche]

I have the following formula

='Z:\Product Change\[PC_0001.xlsx]Product Change Form'!$D$45

What I am trying to achieve is, when I copy this formula into the cell bellow the file name increments by 1 to PC_0002.xlsx
Alternatively is there any way the formula can reference a Cell that will increment when copied
For e.g. cell A1 (in place of the file name PC_0001) but when copied to the cell below the reference changes to A2

[Kevin UK]

Hi peche

Assuming the data is in A1, change the ROW as required.

Please Login or Register  to view this content.

[peche]

Hi Kevin
Thanks for the reply, but I’m unable to get it working.
Allow me to explain what it is I am trying to achieve
I have created two spread sheets, 1 file name PC_0000.xlsx and 2 a spread sheet called “product change register”
PC_0000.xlsx is a blank form that once filled out is renamed sequentially (e.g. PC_0001.xlsx then PC_0002.xlsx and so on).
The register has 5 columns that report back the values of 5 individual cells on the blank form.
As it stands at the moment, every time I save a new form I have to manually change the formulas in the register to point to the newly saved form. I’m trying to find a way to copy and paste the formulas from the row above and have the formula change to look at the newly saved form.
I hope I am making sense?