Johnette Connelley
asked on
Macro to create separate worksheet based on Column value
Hello EE.
I am not very experienced with Macros (but studying them), but I know I most likely need one to handle the project I am currently working on.
Each month, we pull a report of fire district fees from our tax system. We dump the data into Excel (see the worksheet tab "Data - Per IT"), We click the "SORT" button which then populates the tab "REPORT-All Fire Dists". This portion of the report is fine.
However, after this step, they have been manually copying and pasting the individual data for each fire station into a separate worksheet. These worksheets mirror the tab "Report-All Fire Dists" and we want to be able to use a macro to do this automatically for us each month rather than copy and paste the data. I want it to allow for at least 8000 lines of data (what I have given you is a small sample with only 3 fire districts).
The three separate fire district worksheets reveal the end result I am looking for.
The macro can either:
1) create the entire worksheet each time for each fire district
or
2) populate an existing worksheet (meaning I could create a template for each of the fire departments and the macro would copy and paste the information from "Report-All Fire Dists" only for the relevant fire district.)
Thanks for any assistance you can provide with this. Please see my sample file attached.
Experts-Exchange-Example-Fire-Dist-.xlsm
I am not very experienced with Macros (but studying them), but I know I most likely need one to handle the project I am currently working on.
Each month, we pull a report of fire district fees from our tax system. We dump the data into Excel (see the worksheet tab "Data - Per IT"), We click the "SORT" button which then populates the tab "REPORT-All Fire Dists". This portion of the report is fine.
However, after this step, they have been manually copying and pasting the individual data for each fire station into a separate worksheet. These worksheets mirror the tab "Report-All Fire Dists" and we want to be able to use a macro to do this automatically for us each month rather than copy and paste the data. I want it to allow for at least 8000 lines of data (what I have given you is a small sample with only 3 fire districts).
The three separate fire district worksheets reveal the end result I am looking for.
The macro can either:
1) create the entire worksheet each time for each fire district
or
2) populate an existing worksheet (meaning I could create a template for each of the fire departments and the macro would copy and paste the information from "Report-All Fire Dists" only for the relevant fire district.)
Thanks for any assistance you can provide with this. Please see my sample file attached.
Experts-Exchange-Example-Fire-Dist-.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER