davidander
New Member
Request for assistance in getting the prepared.
Requirements:
1. I have a file named "Yearly data.xlsm) in which data is stored in various tabs
2. There is a tab named "Main" from which certain conditions are to be taken (mentioned in below steps) and separate files are to be prepared from the data in other tabs of that file meeting those conditions
3. In "Main" tab of the file there are columns with headings - S.No., Emp Name, Location, Project, Target, Achieved, Desg and few others
4. Other tabs have few of the above headings like Emp Name, Location, Project etc. along with other different different headings in each tab of the file "Yearly data.xlsm"
5. I want separate file to be created for each Emp Name for each Project he is working for. e.g. If David is working in Japan (Location) and several (Project) say on 5, then 5 separate files should be created for David for each Project but only 1 folder should be created for 1 Emp Name and all files for that Emp Name should get stored in that folder. The name of newly created folder should be Emp Name (David in this example) and naming convention for filenames should be Location_Project.xlsx. Note that there might be more than 1 Location for an employee so separate files for each location are required. If you see the attached sheet then output should be 5 folders - David, Andrew, Peter, Henry, Jenny. In David folder there should be 7 files named - Japan_rty.xlsx, Japan_fgh.xlsx, Japan_dsf.xlsx, Austr_tyu.xlsx, US_fewrt.xlsx and US_dsf.xlsx.
6. The data should be copied from each tab except "Main" tab in the newly created files meeting the conditions specified in Step 5 above e.g. for first file Japan_rty.xlsx the file should have tabs zxc, asd, qwe and iop (these tabs are in the attached file) with data where Emp Name is David, Location is Japan and Project is rty.
7. The tabs which don't have any data meeting the above conditions should be deleted
Please let me know if any other info is required.
Requirements:
1. I have a file named "Yearly data.xlsm) in which data is stored in various tabs
2. There is a tab named "Main" from which certain conditions are to be taken (mentioned in below steps) and separate files are to be prepared from the data in other tabs of that file meeting those conditions
3. In "Main" tab of the file there are columns with headings - S.No., Emp Name, Location, Project, Target, Achieved, Desg and few others
4. Other tabs have few of the above headings like Emp Name, Location, Project etc. along with other different different headings in each tab of the file "Yearly data.xlsm"
5. I want separate file to be created for each Emp Name for each Project he is working for. e.g. If David is working in Japan (Location) and several (Project) say on 5, then 5 separate files should be created for David for each Project but only 1 folder should be created for 1 Emp Name and all files for that Emp Name should get stored in that folder. The name of newly created folder should be Emp Name (David in this example) and naming convention for filenames should be Location_Project.xlsx. Note that there might be more than 1 Location for an employee so separate files for each location are required. If you see the attached sheet then output should be 5 folders - David, Andrew, Peter, Henry, Jenny. In David folder there should be 7 files named - Japan_rty.xlsx, Japan_fgh.xlsx, Japan_dsf.xlsx, Austr_tyu.xlsx, US_fewrt.xlsx and US_dsf.xlsx.
6. The data should be copied from each tab except "Main" tab in the newly created files meeting the conditions specified in Step 5 above e.g. for first file Japan_rty.xlsx the file should have tabs zxc, asd, qwe and iop (these tabs are in the attached file) with data where Emp Name is David, Location is Japan and Project is rty.
7. The tabs which don't have any data meeting the above conditions should be deleted
Please let me know if any other info is required.
