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?

[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...