changing parts of a Text String using Macro's Or VB

[bloodmilksky]

Hi Guys, I hope you are all well?

I was just wondering if anyone can help me with the below question. I have 3 different customers each with their own label but the same information follows that label like below.

Customer A

red+550075110
red+660075110
red+550
red-550075110
red-660075110
red-550

Customer B

blue+550075110
blue+660075110
blue+550
blue-550075110
blue-660075110
blue-550

Customer C

yellow+550075110
yellow+660075110
yellow+550
yellow-550075110
yellow-660075110
yellow-550

these products are spreadacross 7 sheets and the option to select which customer you are ordering for would be on sheet 1. Does any one know how I would be able to use VBA to change these depending on the customer I selected on sheet 1.

any help would be greatly appreciated.

many thanks

Bloodmilksky ^_^

 

[synergy16]

change them how?