Tamamlanmış

simple excel macro

Quick description: I need an excel macro that compare key words in a matrix and if found an X in the matrix it should write this down.

The script needs to run under excel 2010

Take a look at the attached excel test file

detailed step by step:

(Input) copy Range A to G -> (Output) A to G

CounterOutputRow = 1

Loop (until (Output) Cell A of row <CounterOutputRow> is empty)

CounterOutputRow++

CounterInputRow = 1

Loop (until (Input) Cell A of row <CounterInputRow> is empty)

(Output) If Cell C <> "Neutral" then

If the value of (Input) Cell E (maVorname) & Cell F (maNachname) is equal to the value of (Output) Cell E & F and the last 3 letters of Cell D (maUserID) of Input and Output then

compare value of (Input) Cell C and value of (Output) Cell C with (SoD)

If (SoD) X (for the compared values) then

Copy (Input) Cell A in (Output) Cell H (don't overwrite value, add the information in the cell seperated by , if there is already a value in the cell)

EndIf

CounterInputRow++

In this example there are two Peter Mustermann, one with the userIDs qwee1 and qXee1

and the other with the userID qXee2!

The last three letters help identify the user if the name is common.

Only to compare by userID does not work, since some user got two userIDs

The comparison is the tricky part, i.e. Division 1 and 8 got an X but also the other way around Division 8 to Division 1

This is a really small and probably simple taks and I only can spend a small amount on this one.

Beceriler: Veri İşleme, Excel, Visual Basic

Daha fazlasını gör: macros in excel for beginners, macro excel tutorial, how to create a macro in excel 2010, how to create a macro in excel 2007, excel macro examples, excel macros for dummies, how to create a macro in excel 2013, use of macros in excel, excel macro fill empty cells, excel macro data cell, excel 2000 simple sort macro, simple excel data entry macro, quick cut paste excel macro, excel macro simple input output, create simple print macro excel, excel macro quick jobs, microsoft excel macro paste cell details single cell seperated colon, twitter simple excel macro, excel simple reconciliation macro, simple excel macro

İşveren Hakkında:
( 11 değerlendirme ) Burscheid, Germany

Proje NO: #17792618

Seçilen:

mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several excel vba tasks of various complexiteis, I can help you out with solution you need for your excel file. I am available now to s Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 18%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(84 Değerlendirme)
5.7

Bu iş için 16 freelancer ortalamada €24 teklif veriyor

TonmoyRoy111

Hi Client I can write the code for you for the mentioned requirement. Please initiate the conversation with me. Roy

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(261 Değerlendirme)
6.5
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(39 Değerlendirme)
5.8
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(49 Değerlendirme)
5.3
royalcalif

PM me for the solution. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(72 Değerlendirme)
5.3
haleem0786

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro, VBa etc. Please review my profile and inbox [login to view URL]

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(14 Değerlendirme)
3.6
Grisha97924

Hi., I have just completed vba project. I am confident. I have good experience with VBA. I can start work now. Regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(1 Yorum)
2.4
sahinbudak

Hello, I am an excel master. I can build this macro in 1 day. You will the .xlsm file and the source code itself. You can do any change after receiving the code. Hope to work with you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(4 Değerlendirme)
1.8
GIRATOR

. .

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
khansajol082

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss........

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(1 Yorum)
0.0
lakshayaralana96

I could that the work which could satisfy your expectations and I would deliver the completed work very fast.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
vw7923293vw

I can do this in like a day with high quality and excellent, clear, and readable codes. I have done past projects like this, similar to text mining/text processing.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
anmolbhardwaj5

As you already gave me flow chart so I will not charge much. There are few things which I do not understand about procedure. So kindly message me and let us discuss. AsI am not currently working on any other project Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde28%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
ryeshwant

I have extensive experience with excel and macros. I have developed many excellent excel work products. Managing a complete stocks portfolio is one of them. This excel workbook can read contract notes from HTML, store Daha Fazla

in %bids___i_period_sub_35% gün içinde28%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0