I have one spread sheet with two tabs. 1. Detail tab 2. Report Tab. I would like to Update Report tab from Detail tab after grouping and Date filter by VBA code.
I would like to filter Report Date and match with Date column in Detail tab and compare Department column and group by Status and update Report tab. I did manually for Date 5/1/2015 for demo.
I am attaching my excel file for better understanding. I would like to use some name range or define name so in future if i rename column or move column then code will work.