M
MAD
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
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