I am using Excel 2003
I have a price table for each of our products. Ex: Product #xxx - 1 item
cost $100. Price B for 2-5 items cost (=100*.95%), Price C for 5-25 items
cost (=Price B * .80%) ect. Most of the cells have formulas based on another
cell. I want to copy this whole chart as just plain numbers and not as
formulas. Hopefully then I will be able to create a new chart based on the
old numbers by increaseing the old numbers by a % number.
I used to know how to do this, but I have forgotten. Can anyone help me???

Aurora

Hi,
select the range, copy, go to where you want to paste the information, paste
special, values

"MAD" wrote:

I am using Excel 2003
I have a price table for each of our products. Ex: Product #xxx - 1 item
cost $100. Price B for 2-5 items cost (=100*.95%), Price C for 5-25 items
cost (=Price B * .80%) ect. Most of the cells have formulas based on another
cell. I want to copy this whole chart as just plain numbers and not as
formulas. Hopefully then I will be able to create a new chart based on the
old numbers by increaseing the old numbers by a % number.
I used to know how to do this, but I have forgotten. Can anyone help me???

Aurora

and to increase by a % (say by 10% )

--type 1.1 in a unused cell and copy the cell (not the cell content)
--Select the range of numbers to be increased.
--Right clickPaste specialselect 'Multiply' Hit OK


--
Jacob (MVP - Excel)


"Eduardo" wrote:

Hi,
select the range, copy, go to where you want to paste the information, paste
special, values

"MAD" wrote:

I am using Excel 2003
I have a price table for each of our products. Ex: Product #xxx - 1 item
cost $100. Price B for 2-5 items cost (=100*.95%), Price C for 5-25 items
cost (=Price B * .80%) ect. Most of the cells have formulas based on another
cell. I want to copy this whole chart as just plain numbers and not as
formulas. Hopefully then I will be able to create a new chart based on the
old numbers by increaseing the old numbers by a % number.
I used to know how to do this, but I have forgotten. Can anyone help me???

Aurora