VBA Excel Macro

In Progress Posted 5 years ago Paid on delivery
In Progress 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.

Excel Visual Basic for Apps

Project ID: #17217157

About the project

8 proposals Remote project Active 5 years ago

8 freelancers are bidding on average €32 for this job

schoudhary1553

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

€50 EUR in 1 day
(339 Reviews)
8.0
dvcontact

Hi, Reading your project description about writing a macro to check/compare data in your sheet makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Before you award this More

€30 EUR in 1 day
(56 Reviews)
6.5
Phooka18

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

€23 EUR in 5 days
(13 Reviews)
4.5
liangjongai

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.

€55 EUR in 1 day
(5 Reviews)
4.3
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB. I also saw the pictures yo More

€23 EUR in 100 days
(14 Reviews)
3.5
anas2370

I am a professional data entry expert and have extensive knowledge of MS Word and MS Excel and can do extensive data research on web of any kind profile: Bachelor's degree in economics. Master in Marketing. Exp More

€16 EUR in 10 days
(0 Reviews)
0.0