K
kevint
Hi all: I have a workbook with 75 worksheets. I have one set up for each
truck in our fleet. I use it to record details and conversations with
the drivers. I have a script that someone on here sent me that date and
time stamps each new entry. What I would like to do is have a main page
with a cell that I would input the truck number which would in turn "go
to" the proper work sheet for that truck. I can edit the worksheet name
as the truck #, and go to it by clicking the tab, but this means a lot
of scrolling to get to the appropriate worksheet. I now have a main
page set up with 75 macro buttons with a "go to" macro to each sheet
but it requires a lot of maintenance as trucks come and go and the
numbers change on a frequent basis. Is there a way that I can have an
input cell where I can input the truck # and go directly to the proper
worksheet.
Thanks Kevin
truck in our fleet. I use it to record details and conversations with
the drivers. I have a script that someone on here sent me that date and
time stamps each new entry. What I would like to do is have a main page
with a cell that I would input the truck number which would in turn "go
to" the proper work sheet for that truck. I can edit the worksheet name
as the truck #, and go to it by clicking the tab, but this means a lot
of scrolling to get to the appropriate worksheet. I now have a main
page set up with 75 macro buttons with a "go to" macro to each sheet
but it requires a lot of maintenance as trucks come and go and the
numbers change on a frequent basis. Is there a way that I can have an
input cell where I can input the truck # and go directly to the proper
worksheet.
Thanks Kevin