Hi All,
I am trying to create separate workbooks for each value in a field. Basically, I have 45 different Departments and need to create a workbook for each with the data in the main worksheet. I've been able to do this by creating separate sheets and then creating workbooks, but for some reason it's going extra slow, so I was hoping to take the step of creating the sheet out. My data is in a table called "DetailData" and the field name is Department. I have already defined a filepath to save to and named in Departments & Format(Date, "mm.dd.yy"). I think I can navigate the saving part, it's just getting the workbooks created. All help is appreciated!
I am trying to create separate workbooks for each value in a field. Basically, I have 45 different Departments and need to create a workbook for each with the data in the main worksheet. I've been able to do this by creating separate sheets and then creating workbooks, but for some reason it's going extra slow, so I was hoping to take the step of creating the sheet out. My data is in a table called "DetailData" and the field name is Department. I have already defined a filepath to save to and named in Departments & Format(Date, "mm.dd.yy"). I think I can navigate the saving part, it's just getting the workbooks created. All help is appreciated!