Hi all
I have a workbook that reports due dates for documents to be reviewed. I have 11 Business Divisions that need to get a copy of there due and past due documents only. To eliminate having to filter and copy and paste information to a new workbook and save etc was hoping a macro would be quicker... I have tried various code and nothing seems to do what i want.
(Due dates are by Qtr and calendar year) - my master workbook contains 2 worksheets -
I need to create 11 versions of this master sheet with an individual Business Divisions (BD) information only. The Business Division codes are with a column so I thought a macro that filters the relevant BD and then save as a new file would work and this did however I will have to run 11 individual macros to create individual workbooks and run these reports... is there a way to run these 11 macros together considering they are within different workbooks..
..realising that a file path will need to be added
tia
shaz
I have a workbook that reports due dates for documents to be reviewed. I have 11 Business Divisions that need to get a copy of there due and past due documents only. To eliminate having to filter and copy and paste information to a new workbook and save etc was hoping a macro would be quicker... I have tried various code and nothing seems to do what i want.
(Due dates are by Qtr and calendar year) - my master workbook contains 2 worksheets -
I need to create 11 versions of this master sheet with an individual Business Divisions (BD) information only. The Business Division codes are with a column so I thought a macro that filters the relevant BD and then save as a new file would work and this did however I will have to run 11 individual macros to create individual workbooks and run these reports... is there a way to run these 11 macros together considering they are within different workbooks..
..realising that a file path will need to be added
tia
shaz
