C
computerangel
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!
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!