Hi Experts, I have looked through the EE and there are quite a few examples of filter and count but,
I need to filter, then count the number of items in the filter and put the result onto Sheet1 in cell E6
i.e. on the active sheet when I filter column N with a date [that is input through an input box] lets say there are 8 items in the filter I need to then put 8 in sheet1 in cell E6
Hope someone can help.