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:
<tbody>
</tbody>
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:
A | B | C | |
1 | Date | Variable A | Variable B |
2 | 10/27/15 | 65 | |
3 | 65 | ||
4 | 10/26/15 | 67 | |
5 | 60 |
<tbody>
</tbody>
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