Mark up price list

You can use this code (ONCE!):

Please Login or Register  to view this content.

Where 10 is the amount of columns with data in your sheet - change as adequate.

Originally Posted by bethvan

Hello,
I have numerous product price lists in Excel format to which I need to add 20% to each price. There are multiple product worksheets, 10's of components for each product & multiple columns of increasing quantities. What is the easiest way to add 20% to each number? Is paste special & choosing multiply effective?
Thanks in advance!

Yes or if you want to use a macro,
set the range you require
A1 is the value you multiply by, 20% would be 1.2

Please Login or Register  to view this content.