Adding Across WorkSheets
 

Please help! I have 600 cases worked on from May through July- there were
duplicates listed too. I need to figure out how many unique cases were worked
on through this time and I know that this list is going to keep growing.

I need to:
1. Perform an advance filter on unique text on Worksheet A and save it to
Worksheet B.
2. Count (COUNTA) the unique text on Worksheet B
3. Then auto update Worksheet A with Worksheet Bs count
4. And record this Macro

My issue is:
1. I don't know if this is the best way to go to accomplish this
2. In Step 3. What is the formual to update worksheet A automatically with
worksheet B's Count?
3. If I can set up a running count? How do I do that?

Thank you for your help! : )

ca