Automatically incremement excel workbook references?

[swimmerhair]

Hi all, I am trying to automatically increment workBOOK references using the INCREMENT function.

I have so far thi:

=INDIRECT("'pathname part 1" & A$1 & "pathname part 2" & A$1 &"'!G24")

But it is giving me reference errors. Is there a way to do this with this code?

 

[Gerald Higgins]

I don't recognise the INCREMENT function but the INDIRECT function should do this.

It's hard to give a more precise answer without knowing what your workbook names are, and the directory name might also be relevant.

I suspect that there is an error somewhere in your INDIRECT function, so that the result is not exactly matching the correct pathname and workbook name.

Consider using the Formula, Evaluate function, which might show you what is going wrong.