One click, change 200 cells by x percent

[atmospheric]

My "quotation" spreadsheet contains about 200 prices for raw materials (from one supplier). Recently he increased prices by 2.5% across the board. Without using VBA, which I am just learning, is it possible to PERMANENTLY increase these prices at a stroke, bearing in mind that this will happen again in the future. By that I mean that if I succeed in increasing them by 2.5% now, and if another rise occurs of say 3%, that is NOT a total rise of 5.5%. Does this make sense? All prices are in a single column, part of a lookup table.
Thanks in advance.

 

[Juan Pablo González]

In ONE strock, no. But, you can put 2.5% in a cell, copy it, select the cells you want to modify, paste special, and select "Values" and "Multiply".

 

[atmospheric]

What can I say? You're a genius....worked straight away. Many thanks

 

[Smurfit-Stone]

Thanks Guys.....that worked beautifully.