I have an Excel 2k spreadsheet with product numbers &
product descriptions & product pricing. Periodically I
need to change prices of 300 products by a certain
percentage all at once. What would be the best way to do
this? What I would like to do is have something promtp me
for a portion of the product number or product description
and then prompt me for the percentage the product needs to
be marked up or decreased by then is changes all the
prices for me.
Will Excel even do this?
Thanks for any help you can lend this struggling sales
person.