Hi, I'm assuming this is extremely easy, but I'm trying to figure out how to have the row number change when I copy the following equation down.
=INDIRECT("'"&F$7&"'!e85")
Where cell F7 refers to the tab that I want to pull cell E85 from. Thus, when I copy the equation down, I would like cell E85 to change to E86, etc.
Any help would be truly appreciated.
Thanks.
Terry
Bookmarks