cell formula to reference current workbook

[jammoca]

I have the following formula ...

='[QSMAA11_3b.xlsm]ZZ Generate Class Profiles'!I24

However, I was hoping to have the formula a little fluid in that it would reference whichever workbook that formula finds itself in.

So if copied across to a workbook called .... Bleeding .... then the formula would automatically adjust itself to ....

='[Bleeding.xlsm]ZZ Generate Class Profiles'!I24

Is this possible ?

 

[MrKowz]

Omit the workbook reference altogether.

 

[jammoca]

I should have said, that currently my formula is without the workbook reference, so my formula is the following ...

='ZZ Generate Class Profiles'!I24

But when I copy it to a different workbook either manually or even via the 'move/copy' option, either way, the formula has my workbook address written into it automatically, so it copies across as ...

='[QSMAA11_3b.xlsm]ZZ Generate Class Profiles'!I24

So, I'm hoping to have the original formula written in such a way so as to understand it is to reference the workbook it has been transferred over to and NOT from the workbook from which it was copied.

Is this possible ?

 

[MrKowz]

Try:

=INDIRECT("'ZZ Generate Class Profiles'!I24")