close

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: www.excelforum.com/member.php...oamp;userid=33952
View this thread: www.excelforum.com/showthread...hreadid=537274Enter 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 gt;,
cerebro gt; wrote:

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


thank you very much for a quick response.--
cerebro
------------------------------------------------------------------------
cerebro's Profile: www.excelforum.com/member.php...oamp;userid=33952
View this thread: www.excelforum.com/showthread...hreadid=537274

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()