So I have a data dump of employee data that shows headcount (yellow section) and when the headcount is added or reduced by month (green section). I need to create a report on a monthly basis that shows the adds and reductions by month. As of right now I am manually going into the green section of the attached sheet by month and manually filtering by either a -1 (reduction) or 1 (addition) and pasting the employee name, department, etc. to another sheet to create this adds/reductions report. Any suggestions on how to automate this? I was trying to go the macro route, but got stuck at figuring out how to move to the next visible row when a filter was applied. Anyone think there would be an easier way to do this without using macros? Any suggestions would be much appreciated. This simple task is taking me waaaayyyy to long to do every month. TIA.
Bookmarks