andreyman3d2k
asked on
Excel 2007 Macro to perform several tasks
Hi,
I have a program that puts out some data tables on a sheet with some useless data in-between. (Example is sheet "test" in attached file -- it only shows two data tables, but could be more). I need to consolidate those tables into a single table, get rid of the data in-between, and add a few columns.
I also need to remove duplicates by two criteria, and give a count of all the duplicates removed.
The other sheet, "Result" shows what the final output should be, and has a list of all the things that have to happen.
I tried a bunch of stuff with macro recorder, came close, but not cigar (and it was a mess). Would be grateful if someone with VBA skills could help.
Thank you very much, in advance!
Andrey
EEquestion-Excel.xls
I have a program that puts out some data tables on a sheet with some useless data in-between. (Example is sheet "test" in attached file -- it only shows two data tables, but could be more). I need to consolidate those tables into a single table, get rid of the data in-between, and add a few columns.
I also need to remove duplicates by two criteria, and give a count of all the duplicates removed.
The other sheet, "Result" shows what the final output should be, and has a list of all the things that have to happen.
I tried a bunch of stuff with macro recorder, came close, but not cigar (and it was a mess). Would be grateful if someone with VBA skills could help.
Thank you very much, in advance!
Andrey
EEquestion-Excel.xls
bromy2004
What 2 criteria do you want to remove duplicates by?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome! Thank you very much.
Andrey
Andrey