Hi
I've tried searching (and google'd) for a solution to my problem but i'm stuck, please bear with me here as it's been a very steep learning curve for me over the last few weeks trying to grasp VBA in excel:
I've setup a worksheet whereby rows can be Autofiltered between a start and finish date via a Userform which (after much mucking about with UK/US dates) seems to be working nicely now.
With the results of the Autofilter, i wish to count certain entries (in this case entries that are in column F) in the remaining visible rows.
The Workbook is about 'Cases' worked, and column F relates to how the 'Case' is cleared (Call, Letter, Referral). Effectively I want to be able to count 'Call', 'Letter' and 'Referral' entries once the Autofilter has been applied.
Any help on this would be hugely appreciated.
Thanks
Bookmarks