Macro info please

[le clef]

We have our price lists in worksheets - and every so often we need to adjust
the prices - the prices are in columns within the worksheet, but in different
columns within the same worksheet.

Is there an easy way to adjust these prices (either up or down (!)) by
running a macro ?

My thanks in anticipation.

 

[Bob Phillips]

If it is a uniform increase/decrease, you can enter the multiplier in a
cell, then copy it to the clipboard. Then select all the target cells, and
Edit>PasteSpecial>Multiply. Clear the multiplier and you are done.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[le clef]

Many thanks Bob - that has worked a treat - I am learning all the time !