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
EditPasteSpecialMultiply. 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" wrote in message
...
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.

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

"Bob Phillips" wrote:

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
EditPasteSpecialMultiply. 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" wrote in message
...
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.