discount entire columns

let me give a more precise example of what I'm trying to
do.

I have a number of "list prices" in a column lets say
column "A", rows 5-10 each have a different "list price".
Then I have a mark-up or discount amount ie x 1.4 in cell
A1, I want to be able to change the number in A1 to 1.5 or
1.6 or 1.7 or whatever and have every number in cloumn "A"
rows 5-10 change to the new amount together. without
going to each cell in each column and entering in a
formula for each. they are all diiferent prices, but they
all will have the same discount.

you'll have to forgive me, I used to have a spreadsheet
that did this perfectly that someone else made for me so I
just took it for granted until a virus wiped out my system
now I have no idea how it works lol.

Dan

Hi Dan!

Save your file and then save under a new name so that you can revert to the
original if / when you stuff up vbg

Put the mark up or discount multiplier in an empty cell:

So for mark up you might have 1.2 to mark up 20% and for discount you might
have 0.8 to discount by 20%

Select the mark up / discount cell
Copy
Select the range that you want to mark up or discount
Edit Paste Special
Check Multiply
OK

BTW, it's best to stay in the original thread rather than create a new one
even if you're re-phrasing / re-defining what you want.
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

"dan" wrote in message
...


let me give a more precise example of what I'm trying to
do.

I have a number of "list prices" in a column lets say
column "A", rows 5-10 each have a different "list price".
Then I have a mark-up or discount amount ie x 1.4 in cell
A1, I want to be able to change the number in A1 to 1.5 or
1.6 or 1.7 or whatever and have every number in cloumn "A"
rows 5-10 change to the new amount together. without
going to each cell in each column and entering in a
formula for each. they are all diiferent prices, but they
all will have the same discount.

you'll have to forgive me, I used to have a spreadsheet
that did this perfectly that someone else made for me so I
just took it for granted until a virus wiped out my system
now I have no idea how it works lol.

Dan