TotallyConfused
Board Regular
- Joined
- May 4, 2017
- Messages
- 247
- Office Version
- 365
- Platform
- Windows
I have a blank workbook with two sheets that Excel created, originally called 'Sheet1' and 'Sheet2'. Then I renamed these to be called 'TEST1' (formally Sheet1) and 'TEST2' (formally Sheet2). I have a number in TEST1 cell 'A1' that I need to copy over to TEST2 cell 'A1'. In Sheet2 cell 'A1' I placed the formula: ='TEST1'!A1 and this copied the number exactly as I wished. When I tried to modify this formula to read: ='SHEET1'!A1 all I receive is the error message of #REF!. I then tried using the same formula, except removing the two apostrophes, but the end result was still the same error message. If possible, I would like to use the sheet code name rather than the tab name, so that if someone changes the sheet tab name, the end result won't be disastrous. Also I'd like to stay within Excel if possible, rather than going to VBA. Can this be done, and if so, how would I word the formula?
Thank you in advance for any help or advice you may be able to offer.
TotallyConfused
Thank you in advance for any help or advice you may be able to offer.
TotallyConfused