My office has decided to use Excel to collect data from several managers in
different locations. The workbook will be on a shared server and each person
will enter her data on her own designated worksheet.

Our problem is that we know that if the managers have to scroll along the
bottom to find their worksheet, they'll be less likely to follow through with
recording.

Is there a way to make a switchboard (like in Access--there are reasons
we're not using Access) so that they could click on their unit number and it
would jumb to their worksheet?

When the idea was first proposed, I thought, yes that should be do-able. But
I'm not having much luck.

Thanks.

Insert a blank worksheet and then enter the Unit numbers, one per cell.

Select the first unit number and then click INSERT on the menu and select
HYPERLINK (or press <Ctrl + k)

In the hyperlink dialog box select PLACE IN THIS DOCUMENT in the LINK TO
panel.

Enter the starting cell, or leave it at A1

Then select the worksheet that corresponds to the unit.

Repeat for each of the units in the workbook.
--
Kevin Backmann


"hongloumeng" wrote:

My office has decided to use Excel to collect data from several managers in
different locations. The workbook will be on a shared server and each person
will enter her data on her own designated worksheet.

Our problem is that we know that if the managers have to scroll along the
bottom to find their worksheet, they'll be less likely to follow through with
recording.

Is there a way to make a switchboard (like in Access--there are reasons
we're not using Access) so that they could click on their unit number and it
would jumb to their worksheet?

When the idea was first proposed, I thought, yes that should be do-able. But
I'm not having much luck.

Thanks.

There are many ways that you could accomplish the goal.

The easiest would be to create a Userform and have it set up when the user
opens the Worksheet, the userform pops up and asks for their unit number,
depending on the user number, have the VBA send the user to their designated
worksheet.

That is what I would do, it would take some time to set it up, but there
would be less hassle after completed.

Sorry I'm not that good at programming...yet, so I don't have a sample code,
but I'm sure there are others on the forms that might be able to help. As
those in the Programming VBA section of the Forums.

Another way is, hyperlinks...lots and lots of hyperlinks

that code would be a simple:

Sub UserSheets_Select()
Sheets("---------").Select
End Sub



--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"hongloumeng" wrote:

My office has decided to use Excel to collect data from several managers in
different locations. The workbook will be on a shared server and each person
will enter her data on her own designated worksheet.

Our problem is that we know that if the managers have to scroll along the
bottom to find their worksheet, they'll be less likely to follow through with
recording.

Is there a way to make a switchboard (like in Access--there are reasons
we're not using Access) so that they could click on their unit number and it
would jumb to their worksheet?

When the idea was first proposed, I thought, yes that should be do-able. But
I'm not having much luck.

Thanks.