完了

VBA Excel Macro

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.

スキル: エクセル, アプリ用ビジュアルベーシック

さらに表示: freelance job vba excel macro, vba excel macro, excel vba excel macro mail merge word, vba excel pdf, excel macros, vba excel 2013, macros in excel for beginners, excel macro examples, excel vba programming pdf, excel macro tutorial pdf, vba excel 2016, data processing, excel, visual basic for apps, microsoft excel, reconciliation vba excel macro, vba excel macro split string cells, vba excel macro screen capture, vba excel macro cut paste column, vba excel macro connect mathematica

採用者について:
( 3件のレビュー ) Dubai, United Arab Emirates

プロジェクトID: #17217157

アワード:

nwss1986

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.

€19 EUR 0日以内
(77レビュー)
5.3

9人のフリーランサーが、このジョブに平均€31で入札しています

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 もっと

€50 EUR 1日以内
(261件のレビュー)
7.5
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 もっと

€30 EUR 1日以内
(32件のレビュー)
5.5
sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep もっと

€18 EUR 1日以内
(80件のレビュー)
5.2
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 1日以内
(3件のレビュー)
3.8
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 もっと

€23 EUR 100日以内
(14件のレビュー)
3.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 5日以内
(8件のレビュー)
3.2
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 もっと

€16 EUR 10日以内
(0件のレビュー)
0.0
€44 EUR 1日以内
(0件のレビュー)
0.0