SOLVED

Dynamically referencing other tabs

New Contributor

Hi, 

I am trying to make a reference block that will allow me to dynamically reference a few areas whenever i enter a certain name for a movie theater accounting worksheet

 

[movie name (A1)]

Week                                                                         | Number

[referencing from name from tab of movie week 1] | [referencing number from tab of movie week 1]

[referencing from name from tab of movie week 2] | [referencing number from tab of movie week 1]

 

it doesnt accept ( =(A1)!A3 ) to turn it into =moviename!A3 and it would be easier if this information would copy itself on whenever i just change the movie name and i have looked for other ways to make this work and none of them can do this, is this possible or am i wasting my time? sorry if this is confusing or silly

Thanks

2 Replies
best response confirmed by Speedracer5545 (New Contributor)
Solution

@Speedracer5545 

Try

=INDIRECT("'"&A1&"'!A3")
Worked like a charm, Thanks!
www.000webhost.com