Hello Excel Gurus,
How are you today? Please, I need your expertise on this one. In cell B3 is a value between 1 to 200 , and in range B10:B20 are values somewhere between 1 to 200 as well. I need a code that will match the value of B3 with B10:B20.
If a match is found then copy range E3:H3 and paste values only to the matched row and column E:H
For instance...
Prior to running macro.
B15 = 5
E15 = Blank
F15 = Blank
G15 = Blank
H15 = Blank
B3 = 5
E3 = ABC
F3 = DEF
G3 = GHI
H3 = JKL
Macro manually triggered.
B15 = 5
E15 = ABC
F15 = DEF
G15 = GHI
H15 = JKL
Note:
If data already exist then overwrite.
If no match found then exit sub.
Will appreciate plenty and thanks in advance.
How are you today? Please, I need your expertise on this one. In cell B3 is a value between 1 to 200 , and in range B10:B20 are values somewhere between 1 to 200 as well. I need a code that will match the value of B3 with B10:B20.
If a match is found then copy range E3:H3 and paste values only to the matched row and column E:H
For instance...
Prior to running macro.
B15 = 5
E15 = Blank
F15 = Blank
G15 = Blank
H15 = Blank
B3 = 5
E3 = ABC
F3 = DEF
G3 = GHI
H3 = JKL
Macro manually triggered.
B15 = 5
E15 = ABC
F15 = DEF
G15 = GHI
H15 = JKL
Note:
If data already exist then overwrite.
If no match found then exit sub.
Will appreciate plenty and thanks in advance.