ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   navigating between worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/54653-re-navigating-between-worksheets.html)

exceluserforeman

navigating between worksheets
 
Could you be a bi t more specific?

"Luke" wrote:

Hi, I am after some command/macro where you put a letter in cell A1 of each
worksheet and then you can initiate a fast key to take you there from
anywhere in the spreadsheet.
thanks


Luke

navigating between worksheets
 
Sure, I saw it done in a modelling course once. You label cell A1 in each
worksheet with a letter. You end up with a little menue of these labels.
You type a fast key and the menu comes up. You choose the letter from the
menu and it takes you to that cell in the relevant worksheet.


"exceluserforeman" wrote:

Could you be a bi t more specific?

"Luke" wrote:

Hi, I am after some command/macro where you put a letter in cell A1 of each
worksheet and then you can initiate a fast key to take you there from
anywhere in the spreadsheet.
thanks



All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com