Macro, Scenario, Filtering - What should I do?
 

My issue:
I have an excel worksheet with duplicated data containing matters numbers
worked on.

Objective:
I need to figure out how many matters we worked for the past 6 months
without the duplicates and provide a count at the end of the worksheet.

What I would like to do:
1. Advance Filter the duplicated data on the main worksheet onto a new
worksheet
2. Count the data on the new worksheet
3. Have the count simultanesouly show up on the main worksheet as a grand
total of matters worked on
4. And record this whole process as a macro to make life sweet!

Can this be done? Is there an easier or better way to do it?

Thanks!

Macro, Scenario, Filtering - What should I do?
 

Hi
I think it's the way to do it.

Then post the code here if you need help adjusting the macro afterwards.

Regards,
Per

"computerangel" skrev i
meddelelsen ...
My issue:
I have an excel worksheet with duplicated data containing matters numbers
worked on.

Objective:
I need to figure out how many matters we worked for the past 6 months
without the duplicates and provide a count at the end of the worksheet.

What I would like to do:
1. Advance Filter the duplicated data on the main worksheet onto a new
worksheet
2. Count the data on the new worksheet
3. Have the count simultanesouly show up on the main worksheet as a grand
total of matters worked on
4. And record this whole process as a macro to make life sweet!

Can this be done? Is there an easier or better way to do it?

Thanks!