When see 19 or 22 from a certain cell of the contents of the other two cells will automati

[metrostar]

Example 1:
The content of cell C14 is VSC-CPS-19 * 1.0
Therefore, the content of cell C21 is WSC-IP-3/4 "* 1" tk
And the content of cell C55 is 3/4�

Example 2:
The content of cell C14 is VSC-CPS-22 * 1.0
Therefore, the content of cell C21 is WSC-IP-7/8 "* 1" tk
And the content of cell C55 is 7/8�
May I ask how to write VBA code


Any help would be appreciated!

[TMS]

I have no idea how your sample file relates to the question and examples. There's nothing in cell C14 or C21 or C55.

Is this the correct file?

[metrostar]

Sorry, the wrong file was passed and has been updated

[TMS]

Maybe this (untested):

Please Login or Register  to view this content.

[wk9128]

pls try this code

Please Login or Register  to view this content.

[metrostar]

Wow, TMS , wk9128 you are all really great, Thank you very much

[TMS]

You're welcome. Thanks for the rep.

[wk9128]

@metrostar You're Welcome. Glad to help . Thank You for the feedback and rep.