Hi All:
In the below example, I am trying to look for populated values in Column A (range is A2:A5). If there are, (i.e. this would apply to A2 and A5) then copy/paste the corresponding row value from Col B into Col C. Initially, I tried to use =IF(A2>0, B2, ""). This worked, however I have I have another macro linked to Col C such that when I hit the "enter" key something else happens. Not sure how its possible to both copy active cells from B to C but also to simulate an "enter" on those selected cells that were populated in Col C?
Example Before:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Date[/TD]
[TD]Variable A[/TD]
[TD]Variable B[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10/27/15[/TD]
[TD]65[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD]65[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]10/26/15[/TD]
[TD]67[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Example After (new values are reflected in C2 and C5. Enter Key is pressed on those individual cells):
<tbody>
</tbody>
Thank you for your time and assistance.
Mark
In the below example, I am trying to look for populated values in Column A (range is A2:A5). If there are, (i.e. this would apply to A2 and A5) then copy/paste the corresponding row value from Col B into Col C. Initially, I tried to use =IF(A2>0, B2, ""). This worked, however I have I have another macro linked to Col C such that when I hit the "enter" key something else happens. Not sure how its possible to both copy active cells from B to C but also to simulate an "enter" on those selected cells that were populated in Col C?
Example Before:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Date[/TD]
[TD]Variable A[/TD]
[TD]Variable B[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10/27/15[/TD]
[TD]65[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD]65[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]10/26/15[/TD]
[TD]67[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Example After (new values are reflected in C2 and C5. Enter Key is pressed on those individual cells):
A | B | C | |
1 | Date | Variable A | Variable B |
2 | 10/27/15 | 65 | 65 |
3 | 65 | ||
4 | 10/26/15 | 67 | |
5 | 60 | 60 |
<tbody>
</tbody>
Thank you for your time and assistance.
Mark