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)
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)
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.
16 威客就此工作平均出价 €24
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]
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