Copying Cells on Enter

[RebekahK20_pontiac via OfficeKB.com]

Hi. I'm new to this VBA thing as a co-worker recently left and I was bestowed
his workload. Joy to the World! Oh well it is a chance to learn....

I need to take data from Cells B8 & C8, and copy them into J8 & K8 upon the
user hiting the enter button.

I know this can be done, I'm just lost trying to jump in the middle.

Thanks in advance.

 

[Guest]

Do you want to do this every time the user hits the enter button, or only
when they make a change in cells B8 or C8, or some other frequency?
Dale

 

[RebekahK20_pontiac via OfficeKB.com]

Everytime the user is in those cells and hits enter or tab persay. It will
actually be for any cell in the Column B or C starting at Row 8...

Do you want to do this every time the user hits the enter button, or only
when they make a change in cells B8 or C8, or some other frequency?
Dale

Hi. I'm new to this VBA thing as a co-worker recently left and I was bestowed
his workload. Joy to the World! Oh well it is a chance to learn....

[quoted text clipped - 5 lines]

Thanks in advance.