whole price sheet change

[Michael Higgins]

Hi,
I am trying to change a cost price list into a retail price is there a
simple way to change every single price on a sheet without having to do each
one individually ?


Many thanks

Michael

 

[CLR]

Try on a copy of your file first...........

Maybe put 1.1 in a helper cell somewhere and do Copy .....then highlight
your prices and do Rightclick > PasteSpecial > Multiply.......this will
raise them all 10%

Vaya con Dios,
Chuck, CABGx3

 

[Michael Higgins]

thanks for the fast reply, i might sound slightly slupid here but what is a
helper cell?

 

[Rick Rothstein \(MVP - VB\)]

A "helper cell" is an unused cell in your worksheet that you are going to
use temporarily and then delete its contents after you no longer need it.
So, for the process that Chuck gave you... put 1.1 in an unused cell and
then press Ctrl+C (or pick Edit/Copy from Excel's menu bar); then highlight
the cells you want to increase in value be 10% and select Edit/PasteSpecial
from Excel's menu bar (or from the popup menu that appears on a
right-click); then pick the Multiply option button on the dialog box that
appears and OK your way back to the sheet. You can now unselect and delete
the "helper cell" (which we needed only temporarily for use by the
PasteSpecial process).

Rick

 

[Gord Dibben]

Good example Chuck but from cost to retail is more like 100% in my experience<g>


Gord