Can someone help me on this?
I have 3 columns (Column A = Date,Column B = Area,Column C = Kg)
I want to automatically copy the filtered data on column I (Report) and get the total area and total kg of the the same data (area total column,kg total column) .
Here is the attached sample of my workbook:
Bookmarks