2nd Updating Cell with VBA?

Hello,

Whenever cell A1 has a new value, it is recorded in column K. I would like the VBA code to do the same for cell A2 & column L.

Here is the VBA code that I have used for cell A1:

Please Login or Register  to view this content.

I've attached 2 files.
The file that ends with an 'a' is works as expected.
The file ending in 'b' attempts to do the same thing, but twice, acting on two cells at once and gives an error. I'd like to get this to work, in file 'b'.

Thanks for any help!

Greg

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You can't have two Worksheet Change Events. You need to combine the code into one module.

Test which cell has been changed at the beginning of the code and use If or Select Case to execute the appropriate code for that cell.


Regards, TMS

It would look something like this:

Please Login or Register  to view this content.

Regards, TMS