Changing and saving values on a Pricelist

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

I receive very long price lists from my suppliers almost
on a daily basis and I need to be able to change the price
on all items at the same time (to add my % surcgarge)
before I send them to the final client. How do I do this
most efficiently without leaving the original prices
hidden in the Excel document?
 
assuming your percent is 10%

type in an empty cell 1.1
Then copy that cell and select the price range then the following men
items:
edit:
paste special:
then click on multiply and ok then all you have to do is delete th
cell that says 1.1 and you should be good to go..
 
Back
Top