Have you thought about using the INDIRECT formula?
For example, instead of your formula:
='Mar-2013'!C42
You could use:
=INDIRECT("'" & A7 & "'!C42")
Where the value of A7 would be "Mar-2013".
It really depends on the usage.
Dex
Have you thought about using the INDIRECT formula?
For example, instead of your formula:
='Mar-2013'!C42
You could use:
=INDIRECT("'" & A7 & "'!C42")
Where the value of A7 would be "Mar-2013".
It really depends on the usage.
Dex
Posting Permissions
Reply With Quote
Bookmarks