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.
Hello there, I will start right now and will deliver a perfectly working macro in a couple of hours. please refer my previous projects to know my proficiency in VBA. contact me, if interested. Thanks.
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