Hi, I have a list of wholesale prices for a range of products and I want
to change the price to retail to sell through an ebusiness and was
wondering if I could use excel to increment all the wholesale costs by
say 20 without having to do each by hand. Is it possible to update all
the prices with a few commands or am i going to have to change all 1000
of them by hand. thanks for any help.


--
cerebro
------------------------------------------------------------------------
cerebro's Profile: http://www.excelforum.com/member.php...o&userid=33952
View this thread: http://www.excelforum.com/showthread...hreadid=537274

Enter 20 in a blank cell. Copy the cell. Select your prices. Choose
Edit/Paste Special, selecting the Values and Add radio buttons. Click OK.

In article ,
cerebro wrote:

Hi, I have a list of wholesale prices for a range of products and I want
to change the price to retail to sell through an ebusiness and was
wondering if I could use excel to increment all the wholesale costs by
say 20 without having to do each by hand. Is it possible to update all
the prices with a few commands or am i going to have to change all 1000
of them by hand. thanks for any help.

thank you very much for a quick response.


--
cerebro
------------------------------------------------------------------------
cerebro's Profile: http://www.excelforum.com/member.php...o&userid=33952
View this thread: http://www.excelforum.com/showthread...hreadid=537274