Aug 15 2022 12:46 PM
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
Aug 15 2022 12:57 PM
SolutionAug 15 2022 12:57 PM
Solution