Forum Discussion
Switching/Opening worksheets across 2 workbooks
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.
ok, in Workbook "Quotation Program.xlsm", Sheet "August", type in this formula:
=HYPERLINK("[Quotation Unit Price.xlsm]"&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&"!A1","destination")This will dynamically open "Quotation Unit Price.xlsm" in sheet "August".
If you don't want this to be dynamic, then use this formula:
=HYPERLINK("[Quotation Unit Price.xlsm]#August!A1","destination")This will have the same end result as the previous formula but, you will need to modify, in the formula, "August" to whatever sheet you want to land in your workbook.
For example, if you want to land in the sheet named "June", your formula will look like this:
=HYPERLINK("[Quotation Unit Price.xlsm]#June!A1","destination")Finally, the last "destination" in the formula is simply whatever will be presented on your sheet so you can type in whatever you want.
Hi, Hell but you are an angel that is what i was looking for but could not figure it out, to use help you have to type just the right phrase to get help to give you more or less the correct info. I just could not figure out the #. Thank You so much
Regards