Urgent help required:
I have a excel file with 3 sheets, one sheet has the employee data dump. 2 other sheets have some analysis based on the data in employee data dump.
My analysis makes use of formulae such as 'Countifs', 'Sumifs' etc.
Now i want to split this file into several files based on the employee's department (a column in the data dump has employee's department).
The splits (output) should have all the 3 sheets in excel and it should be having the data of only 1 department and their analysis in other sheets. The sheets with analysis will be connected to the database with formulae.
Suggested Logic to Achieve this:
1) Create a copy of the excel file and save it with the first department name (Say D1).
2) Delete all the rows having any other department's name except D1.
3) Move on to next department (D2) and so on till one file is created for each department.
This way the connections between various sheets will be retained and the analysis shown would be specific to the department with which the file is named.
This is very urgent requirement, requesting help from experts.
I have a excel file with 3 sheets, one sheet has the employee data dump. 2 other sheets have some analysis based on the data in employee data dump.
My analysis makes use of formulae such as 'Countifs', 'Sumifs' etc.
Now i want to split this file into several files based on the employee's department (a column in the data dump has employee's department).
The splits (output) should have all the 3 sheets in excel and it should be having the data of only 1 department and their analysis in other sheets. The sheets with analysis will be connected to the database with formulae.
Suggested Logic to Achieve this:
1) Create a copy of the excel file and save it with the first department name (Say D1).
2) Delete all the rows having any other department's name except D1.
3) Move on to next department (D2) and so on till one file is created for each department.
This way the connections between various sheets will be retained and the analysis shown would be specific to the department with which the file is named.
This is very urgent requirement, requesting help from experts.
