Switching/Opening worksheets across 2 workbooks

Hi, I have workbook1 and workbook2 each with 12 worksheets one for each month January, February etc....... I open workbook1 first and at some time open or switch, if it is already open, to workbook2 ...

excel

Bennadeau
Oct 16, 2020
Hi kobus1305,

Try this:
=HYPERLINK("[c:\test\excel\destination.xlsx]"&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&"!A1","destination")
Obviously, you will need to change "c:\test\excel\destination.xlsx" for your path and your filename.
This will grab the sheet name you are currently in and will open the same sheet in your destination workbook.