Hi all,
I am looking for a way to add a number to a large group of data. I have in the past used the "Paste Special" to achieve this however the data group is so large and the amount of time I am updating means I need a quicker way to do this.

An example of what I am looking to achieve -

The data:

Blue cars: $100 $200 $300 $400 $500
Red cars: $100 $200 $300 $400 $500

I wish to add $5 to the price of all the red cars and $6 to the price of the blue cars. Ideally I would like to type "5" or "6" into a linked cell so it updates all the car prices accordingly.

Any ideas? Thanks all in advance.

Regards,

Ryan