Marking up pricing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 figure:

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

EDIT=>Paste Special==>Operation->Multiply

HTH
 
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 Edit>Paste Special>Multiple>OK>Esc.

All prices will be marked up 10%


Gord Dibben MS Excel MVP
 
Back
Top