Worksheet change

[jumbla]

Hello everyone!

I am wondering if you could help me with the worksheet_Change for two different targets.

MY code is the following:

Please Login or Register  to view this content.

And it is working, whenever anytjing is updated in column A it is updated and copied in column B(worksheet 2). Now the problem I have is that i want to add another target, B1:B50, and only If that target has the word SUM in it, it should copy and update. The problem is that it is copying but NOT updating anything. My code for that is:

Please Login or Register  to view this content.

What shoudl i do?

[PCI]

Perhaps

Please Login or Register  to view this content.

[TMS]

One way:

Please Login or Register  to view this content.

Regards, TMS