Hello,

I'm looking for assistance in the following matter:

I have an employee list that contains many columns. One of the columns is “Department”
Each department has separate workbooks. Each week, I go to the employee list and filter it by a specific department and copy filtered rows into the respective department workbook. I was wondering if anyone is able to provide me a template of code for each workbook that would pull those rows automatically from the employee list.

I know just a bit of VBA (taking classes next semester to learn more) but if you could notate pieces of code and what they do…that would be helpful just for me to keep learning and figuring out how things work.