I would like to know how to show (by link) another sheet name in a cell in Microsoft Excel. ie if I have first sheet called SHEET1 and 2ndd called SHEET2. I want say Sheet1!A1 cell to show SHEET2 without by link without manually typing it. Thank you.
