VBA Excel Macro
€8-30 EUR
Paid on delivery
I need a Macro to check if for each ID under column E, (Type) "Services" exists, if it does, then any other row that has same ID should be deleted. If no type "Services" exists, then all values under Column C (value) for that ID should be deleted and replaced in one cell (whichever cell for that ID) by the amount that is in one cell in column D (amounts are always the same for the same ID).
Please refer to sheet1 attached.
The second run of the Macro should compare sheet1 to sheet2. (after sheet 1 is modified as above).
So Macro will compare the Sum of values for each ID in sheet1 (after modification) and compare if it is equal to the sum of values in sheet2 for that same ID. Also will compare the Level for that ID in sheet1 if it is equal to the level in sheet2 (level is the same in each sheet for the same ID).
If comparing results is the same then do nothing. if there is a discrepancy, then need to copy the rows for that ID from sheet1 and paste them into a new sheet highlighting in red the discrepancy. If ID in sheet1 does not exist in sheet2 then copy all rows for that ID and highlight all rows in red.
I would really appreciate your help with that.
Thanks.
Project ID: #17217157
About the project
8 freelancers are bidding on average €32 for this job
Hello, I can help with you in your project VBA Excel Macro. I have more than 5 years of experience in Excel, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 300+ Projects More
Hello, i read your description and i can do this work for you (please have a look to my profile). Future modifies and support is includet in the offer. I would be happy to do this work. best regards, Michael
I can work for you. I'm interested in your project. I've an experience of works with ms excel and vba. Ping me any time to discuss about this project.