I have a spreadsheet with large amount of pricing from a supplier (3000 cells).

I would like to mutiply those prices by a number and creat a new spreadsheet
for my pricing.

Any help is appreciated

If ALL data is to be multiplied by same figu

In empty cell, put your multiplier and COPY
highlight cells to be changed

EDIT=Paste Special==Operation-Multiply

HTH

"T-Bone" wrote:

I have a spreadsheet with large amount of pricing from a supplier (3000 cells).

I would like to mutiply those prices by a number and creat a new spreadsheet
for my pricing.

Any help is appreciated

Right-click on the sheet tab and "move or copy".

Select "create a copy" and OK.

Now, on the copied sheet enter 1.10 in an empty cell.

Copy that cell.

Select all other cells and EditPaste SpecialMultipleOKEsc.

All prices will be marked up 10%


Gord Dibben MS Excel MVP


On Tue, 12 Jun 2007 12:09:01 -0700, T-Bone
wrote:

I have a spreadsheet with large amount of pricing from a supplier (3000 cells).

I would like to mutiply those prices by a number and creat a new spreadsheet
for my pricing.

Any help is appreciated