Hey all,
I can normally find my way through Excel fairly easily, however, I think I may be too ambitious this time. I am working on a sales tracking sheet for my company and would like to create the following:
A master file that has connections to multiple individual for each sales rep (up to 15). All would be stored on a shared drive, but the master file would only be editable by myself or another manager. This is all fairly easy to create, the issue comes in with adding new sales reps. Does anyone know of a way to create a Macro which would create a new workbook with the sales sheet format of the other connected workbooks and with the same macro create an active data connection between the main workbook and the new branch workbook. My hope is to have the manager simply type in the name of a new sales rep and have the macro run and create the workbook w/ connection to main.
Any suggestions??
I can normally find my way through Excel fairly easily, however, I think I may be too ambitious this time. I am working on a sales tracking sheet for my company and would like to create the following:
A master file that has connections to multiple individual for each sales rep (up to 15). All would be stored on a shared drive, but the master file would only be editable by myself or another manager. This is all fairly easy to create, the issue comes in with adding new sales reps. Does anyone know of a way to create a Macro which would create a new workbook with the sales sheet format of the other connected workbooks and with the same macro create an active data connection between the main workbook and the new branch workbook. My hope is to have the manager simply type in the name of a new sales rep and have the macro run and create the workbook w/ connection to main.
Any suggestions??
