Hello,
I currently have a workbook(s) that requiremonthly disbursement of specific tabs/worksheets to various file paths on amonthly basis. In short, here are my parameters:
1. I will be referencing a cell to indicate whatthe name of the new folder will be; ex. cell a1 will be "1 Feb16"
2. The folders will have specified path(s) withcell a1 being the folder that needs to be created; ex. S:\NCH Physician Reporting\Departmentof Anesthesiology\2016\ "cell a1"
3. In some cases the 1 Feb16 folder may havealready been created and the code needs to recognize that
4. The data on the sheets need to be valuesonly.
5. The name of the new workbook(s) will also bedifferent as 3 of the tabs/worksheets may belong to a department. So I wouldlike any specified Anesthesia files to be saved as "Anes Financials Feb2016."
I have bits and pieces so far, but I figured Iwould give this forum a shot. I'm excited to hear from all of the experts.
I currently have a workbook(s) that requiremonthly disbursement of specific tabs/worksheets to various file paths on amonthly basis. In short, here are my parameters:
1. I will be referencing a cell to indicate whatthe name of the new folder will be; ex. cell a1 will be "1 Feb16"
2. The folders will have specified path(s) withcell a1 being the folder that needs to be created; ex. S:\NCH Physician Reporting\Departmentof Anesthesiology\2016\ "cell a1"
3. In some cases the 1 Feb16 folder may havealready been created and the code needs to recognize that
4. The data on the sheets need to be valuesonly.
5. The name of the new workbook(s) will also bedifferent as 3 of the tabs/worksheets may belong to a department. So I wouldlike any specified Anesthesia files to be saved as "Anes Financials Feb2016."
I have bits and pieces so far, but I figured Iwould give this forum a shot. I'm excited to hear from all of the experts.