Macro info please

  • Thread starter Thread starter le clef
  • Start date Start date
L

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.
 
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)
 
Back
Top