Using VBA macro, Is there a way to copy the value in a cell from one workbook that has, ex, value is "X" in cell A2 workbook1 sheet 1 and paste that value into another workbook, but the pasted value is a Yes/No in cell A2 in workbook2 sheet1 if that cell is the value X?
Example shown below
Workbook 1Sheet 1
A | B
1 Yes | No
_________
2 X |
3 | X
Workbook2 sheet1
A | B
1 Yes | No
___________
2 Yes |
3 | No
Example shown below
Workbook 1Sheet 1
A | B
1 Yes | No
_________
2 X |
3 | X
Workbook2 sheet1
A | B
1 Yes | No
___________
2 Yes |
3 | No