Trigger Changing Values using another cell

[mandarin]

Is it possible to use another cell to change an existing trigger?

ex a simple trigger such as LAY-TL10 in Q5 and I wanted to change the ticks from 10 to 12 by entering the value 12 in another cell, say AA5. What would be the format of the trigger to allow that?

[Captain Sensible]

In Q5 you'd just have

Code: Select all

="LAY-TL"&AA5

[mandarin]

Thanks and how about a more complicated Trigger again just wanting to change the ticks?

LAY-TL10-SL10-IP

[Captain Sensible]

Code: Select all

="LAY-TL"&AA5&"-SL10-IP"

Just have your text enclosed by quotation marks and use the '&' to join everything up

[mandarin]

Cheers every day is a school day

[vanbuuts]

You can also use the concatenate function in Excel but Captains formula is slicker