Make File Macro

[Will03]

Hello I have a workbook (attached) that sends data in the master sheet to the corresponding tabs in the workbook. Basically the Information is added to the Master Tab and then with the click of a button the data is sent to the corresponding sheets.

This is how we do the report: There are 9 different pay groups.
Add the employees id number to column A and column G populates a pay group for the employee... so if I only have 4 employees belonging to different pay groups to report this week only 4 tabs should populate with data and 4 files created from there when I run the macro... Here are my issues:

1. All other tabs will populate with the same data as in my Master sheet with all 4 employees when ONLY the 4 Pay Group Tabs should be populated
2. New CSV files will be created for the 9 Pay Groups, when only 4 Files should be created

What I would like to add is for the data in the master to be transferred to the historical tab before the master sheet is emptied. So if I run the report this week and only have 4 employees in the master those four should be put in the Historical and then every time I run it for the new employees to be added to the historical tab below the previous employees so we can keep a historical of employees there.... IN THE ATTACHED FILE THE MACRO WAS RUN PLEASE CLEAR DATA FROM THE SHEETS TO RECREATE THE ISSUES...

Here is the code:

Please Login or Register  to view this content.

[Will03]