Windows 10 How can I put a shortcut on my Windows 10 desktop that will open a particular Excel .xlsx file to a certain tab and go to a given cell?

  • Thread starter Thread starter sayPatricio
  • Start date Start date
S

sayPatricio

I keep one workbook file (2023_Job-16087.xlsx) with several worksheet tabs (January, February, March, ...) and every month make a 'current' shortcut for other users. I want to get the user to the right file & tab automatically to record data. The shortcuts always stay in the same folder, say O:\Jobs\Copy Counts\ and each month the new shortcut (replacing last months' shortcut) points to and opens the proper location for any user to start recording information. Is this possible - to make the opened file jump to the correct tab?

Continue reading...
 
You must log in or register to reply here.

Similar threads

L
Windows 11 How to link to a specific cell in a specific worksheet in an XLSX file from another XLSX
Replies
0
Views
14
LordenFamily
L
B
Windows 11 How do I make a shortcut on the desktop for all users that log into a particular workstation? Windows 11 Pro
Replies
0
Views
6
Brian Skuzinski1
B
S
Windows 11 How can I create a Windows 11 desktop shortcut to a Windows app? I am already setup the Administrator on my computer.
Replies
0
Views
7
Sailorlion
S
B
Windows 11 How can I disable middle click to open a new tab in File Explorer?
Replies
0
Views
36
Blain Gunter
B
J
Windows 10 How do you create a link to a specific cell in an excel file on a shared drive that can be used outside of excel or word?
Replies
0
Views
17
Jeff F88
J
Back
Top