keresztesi
08-19-2018, 01:38 AM
Hi,
I need your help.
Here is a sample table.
So I need the following:
1. IF ColE and ColF are not blank and ColG is blank then
2. Copy the values from ColE and ColF to another workbook
3. ColH contains the workbook name (path will be always the same)
4. It should copy these values to the given workbook, given worksheet column number 8 and 9
5. For row number it should search for "AZON" in colA which is identical in source and destination workbooks ("AZON" is always in ColA)
6. After copy was succesfull it should write an "x" to ColG in the sourcesheet
A
B
C
D
E
F
G
H
I
1
AZON
Terület
Probléma leírása
Kategória
Felelős
Határidő
Visszaküldve
file
KÉSZ
2
terület1_1
CORAZZA
sfgfsgfg
Sebességet befolyásoló
John Doe
2018.08.31
terület1
3
terület1_2
REX
sfgvsfgf
Munkabiztonság
terület1
4
terület3_1
TZR1
ethbet
Akut
terület3
5
terület4_1
CORAZZA
aaaa
Preventív
Paula Abdul
2018.09.10
x
terület4
So, in that example the code should copy values "John Doe" and "2018.08.31" to the workbook "terület1". Row number is where "terület1_1" is in workbook "terület1", the values go to row numbers 8 and 9. After that it writes an "x" to column G.
Thank you in advance!
Zoli
I need your help.
Here is a sample table.
So I need the following:
1. IF ColE and ColF are not blank and ColG is blank then
2. Copy the values from ColE and ColF to another workbook
3. ColH contains the workbook name (path will be always the same)
4. It should copy these values to the given workbook, given worksheet column number 8 and 9
5. For row number it should search for "AZON" in colA which is identical in source and destination workbooks ("AZON" is always in ColA)
6. After copy was succesfull it should write an "x" to ColG in the sourcesheet
A
B
C
D
E
F
G
H
I
1
AZON
Terület
Probléma leírása
Kategória
Felelős
Határidő
Visszaküldve
file
KÉSZ
2
terület1_1
CORAZZA
sfgfsgfg
Sebességet befolyásoló
John Doe
2018.08.31
terület1
3
terület1_2
REX
sfgvsfgf
Munkabiztonság
terület1
4
terület3_1
TZR1
ethbet
Akut
terület3
5
terület4_1
CORAZZA
aaaa
Preventív
Paula Abdul
2018.09.10
x
terület4
So, in that example the code should copy values "John Doe" and "2018.08.31" to the workbook "terület1". Row number is where "terület1_1" is in workbook "terület1", the values go to row numbers 8 and 9. After that it writes an "x" to column G.
Thank you in advance!
Zoli