Hi all, I know there is a simple way to reference a cell on another worksheet - but can it be done by formula?
In sheet 1 and sheet 2 of the attached workbook I have data in column A.
In sheet 3 I want to reference a specific cell in each sheet. I know I can manually type =Sheet1!A7 into cell H3 of sheet3, but can I use a formula to use the Sheet name and cell reference to do this (the cell reference may change from time to time)
Yep. In your example
=INDIRECT("'"&G3&"'!"&$H$2)
in H3 and copy down
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Super, thanks Glenn, knew there had to be a way
You're welcome. There's not much Excel can't do, except make a cuppa, perhaps. Thanks for the Reputation..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks