Each month, we run a report to perform a distribution of fees for various fire districts in the county. This data is dropped into this excel program on the "Data" worksheet. From there, a staff member has been sorting the data in Column E (Fire District Description) and then cutting and pasting the rows of data for that fire district to the matching worksheet. For example, rows 2A through J8 would be copied to the worksheet named FD1 and pasted in cell A8 (we leave row 7 blank between the headers). We only want the data from column A thru J to copy over to each worksheet as there are formulas in columns L thru R that will calculate once the data arrives. I am sure we could automate the formulas to generate as well only when data is present, but I am new to macros and would be satisfied if we could simply get the data to go to the appropriate worksheets by using a button to click once the data is dumped on the "Data" worksheet.
I've allowed for data up to row 4,000 as I don't believe we will ever exceed that number of rows.
I have attached a sample file.
Pay no attention to the other three worksheets (REPORT-ALL FDs, JE and RECAP). I left them in place in the event that adding in other worksheets would alter the macro so I wanted you to see the exact order of the worksheets.
Each month, we would like to automate this process so that once we dump the data on the "DATA" worksheet, we can use a button to click and have the data copy over automatically. We would also like to be able to clear it afterwards to prepare for the next month.
Thanks for any help you can provide with this.