Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filtering macro | Excel Worksheet Functions | |||
Filtering slows down a macro | Excel Worksheet Functions | |||
Filtering with a macro | New Users to Excel | |||
Combo Box Filtering Macro | Excel Discussion (Misc queries) | |||
Combo Box Filtering Macro | Excel Discussion (Misc queries) |