How would you refer to a cell from a different worksheet but in the same XLS file for use with a formula? I know if it's the same worksheet, you just put = and click on the cell you want to refer to.
Thanks.
Last edited by fred2028; 03-08-2011 at 03:09 PM.
=Sheet1!A1
=Sheet2!$A$1
etc
Basically, do the same thing. Type =, click on the tab for the sheet and then select the cell.
Regards
Oh OK. What if the worksheet name has spaces?Originally Posted by TMShucks
Put it in single quotes.
If you follow the approach outlined, it will be done for you.
Regards
OK thank you very much! I'm so happy this was sorted out so quickly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks