I have a master workbook named "workbook1" which a user is required to populate with information from a separate document called "companydoc". In a company used program, there is a feature that allows the user to download information in an excel format. The user is required to download this data and then copy and paste it into workbook1. I am trying to create a shortcut key to do this.
The title of the document that is downloaded from the company program is always "companydoc" and defaults to a read only format. The current user process is: have workbook1 already open, go to the company program and click on the download to excel feature in the program, (the "companydoc" now appears) , on the "companydoc" left click on the small square box to the left of column A and above row 1 which highlights the entire document, then click merge and center (a must), then right click, select copy, go to the master workbook named "workbook1" and on "sheet1" right click on cell A1, choose paste special - All using source theme.
I am trying to create a shortcut key which does this process automatically. The user would be required to have "workbook1" already open and after clicking the download to excel feature in the company program, the user can simply press a shortcut key to automate the copy and paste feature.
Any suggestions?
The title of the document that is downloaded from the company program is always "companydoc" and defaults to a read only format. The current user process is: have workbook1 already open, go to the company program and click on the download to excel feature in the program, (the "companydoc" now appears) , on the "companydoc" left click on the small square box to the left of column A and above row 1 which highlights the entire document, then click merge and center (a must), then right click, select copy, go to the master workbook named "workbook1" and on "sheet1" right click on cell A1, choose paste special - All using source theme.
I am trying to create a shortcut key which does this process automatically. The user would be required to have "workbook1" already open and after clicking the download to excel feature in the company program, the user can simply press a shortcut key to automate the copy and paste feature.
Any suggestions?
