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?

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

S
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
15
Sailorlion
S
J
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
106
Jeff F88
J
D
I need help in how to make an app which I have on my computer - a default app for certain file type, when computer thinks (wrongly) that app is not p
Replies
0
Views
87
David Tselnik
D
R
I have on my Windows 10 computer a file called "22" (no extension) which is 85.5GB. How do I find out what this file is, and whether it is safe to del
Replies
0
Views
58
RowanSylvester-Bradley
R
S
My USB drive will not open and I'm getting a dialogue box saying the disk has to be reformatted. How can I recover my files from this USB?
Replies
0
Views
77
Sue D. 501
S
Back
Top Bottom