Thread
:
Dynamic cell reference using INDIRECT..
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
[email protected]
[_2_]
external usenet poster
Posts: 8
Dynamic cell reference using INDIRECT..
Hi,
Is there a way to take this formula "=INDIRECT("'"&$P$3&"'!X9")" and
make X9 dynamic upon copying to other cells? For P3 I only need to
remove the $'s.
Thanks!
- Alden
Reply With Quote
[email protected]
[_2_]
View Public Profile
Find all posts by
[email protected]
[_2_]