Dear Excel Gurus,
I once pray for your wisdom as I am not worthy of this...
Guys, I have a question, I am trying to figure out, what is the "easiest" (besides manual) to merge values from one column to another.
to be more precise,
<tbody>
</tbody>
So the rule should be like this and should run to the whole worksheet.
IF Column B = TRUE than Copy Value of Column A and Paste it to Column C
So with that VBA ran, the result should look like this:
<tbody>
</tbody>
I hope I have explained it well enough. Unfortunately, I cannot upload anything from my work PC. But if its requested, I can do it later at home.
THANK YOU VERY MUCH IN ADVANCE.
Kind regards
Ildestino
I once pray for your wisdom as I am not worthy of this...
Guys, I have a question, I am trying to figure out, what is the "easiest" (besides manual) to merge values from one column to another.
to be more precise,
Column A | Column B | Column C | Column D |
7 Char Description | 7 Char Descr. Check | 3 Digits Description | 3 Digis Descr. Check |
Tab Mex | FALSE | MEX | TRUE |
TAB Bra | FALSE | BRA | TRUE |
TAB ECU | FALSE | ECU | TRUE |
CZE/SVK | TRUE | /SVK | FALSE |
BIH/HRV | TRUE | /HRV | FALSE |
GBR/IRL | TRUE | /IRL | FALSE |
PLR PRT | FALSE | PRT | TRUE |
PLR CAN | FALSE | CAN | TRUE |
HUN/POL | TRUE | /POL | FALSE |
<tbody>
</tbody>
So the rule should be like this and should run to the whole worksheet.
IF Column B = TRUE than Copy Value of Column A and Paste it to Column C
So with that VBA ran, the result should look like this:
Column A | Column B | Column C | Column D |
7 Char Description | 7 Char Descr. Check | 3 Digits Description | 3 Digis Descr. Check |
Tab Mex | FALSE | MEX | TRUE |
TAB Bra | FALSE | BRA | TRUE |
TAB ECU | FALSE | ECU | TRUE |
CZE/SVK | TRUE | CZE/SVK | TRUE |
BIH/HRV | TRUE | BIH/HRV | TRUE |
GBR/IRL | TRUE | GBR/IRL | TRUE |
PLR PRT | FALSE | PRT | TRUE |
PLR CAN | FALSE | CAN | TRUE |
HUN/POL | TRUE | HUN/POL | TRUE |
<tbody>
</tbody>
I hope I have explained it well enough. Unfortunately, I cannot upload anything from my work PC. But if its requested, I can do it later at home.
THANK YOU VERY MUCH IN ADVANCE.
Kind regards
Ildestino