whole price sheet change
 

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

whole price sheet change
 

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

whole price sheet change
 

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

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

whole price sheet change
 

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


"Michael Higgins" wrote in message
.uk...
thanks for the fast reply, i might sound slightly slupid here but what is
a helper cell?

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

whole price sheet change
 

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


Gord

On Sun, 20 Jan 2008 14:51:02 -0500, "CLR" wrote:

.this will
raise them all 10%