I have a lot of spreadsheets in my workbook. I'm looking for a way to open a spreadsheet using its name, I received from some other application, without to find out the spreadsheet tab.
I have a lot of spreadsheets in my workbook. I'm looking for a way to open a spreadsheet using its name, I received from some other application, without to find out the spreadsheet tab.
Welcome to the forum.
If you want to quickly go to a sheet named Example then click in the Name Box (to the left of the formula bar, under the ribbon) and type Example!A1.
If the name has spaces, then use inverted commas (single quotation marks) to surround the name - for example, use 'Annual Summary'!A1 to go to a sheet named Annual Summary.
Hope that helps.
Last edited by Aardigspook; 06-09-2016 at 07:13 AM. Reason: Add instructions for sheets with spaces
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Good Stuff.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks