cmendez
10-03-2014, 03:08 PM
Hi,
I am currently running a macro that runs through a workbook and outputs other workbooks and saves them indipendently.
What I am having trouble doing is that I have a list of people that only get certain reports and I need to find a way to seperate the outputs into their own folders.
For example,
Person 1 and Person 2 each get 15 reports a piece, each report is different, once my macro outputs those 30 reports I need it to sort them into their own folders for Person 1 and Person 2.
I am really new at this so my only solution to this is have a MkDir for each person then FileCopy and refer back to each file, which works but is time consuming doing this for 86 people.
I am currently running a macro that runs through a workbook and outputs other workbooks and saves them indipendently.
What I am having trouble doing is that I have a list of people that only get certain reports and I need to find a way to seperate the outputs into their own folders.
For example,
Person 1 and Person 2 each get 15 reports a piece, each report is different, once my macro outputs those 30 reports I need it to sort them into their own folders for Person 1 and Person 2.
I am really new at this so my only solution to this is have a MkDir for each person then FileCopy and refer back to each file, which works but is time consuming doing this for 86 people.