11-11-2009, 01:00 PM
Yes the prices are usually in 1 column, but some time in two. but if this is a problem i can copy single price column to empty sheet and after macro runs over it copy it back.
About the dialog. I havent done it before so it might take a looong time to provide it. Maybe i dont need the dialog, i can change the constant variables in the code manually.
The thing is that the % added to the price always depends on the value of the initial price. Like if price is 0.52 usd i add like 20% to the price but for example if the price is higher like 1000 usd i add only 2% and so on. So each time i run the macro for different sheet i need to set % i add for given price range (or use deflaut). So i need to control two things the price range and % to add. For ex. i set 4 price range and 4 different % to add accordingly:
price value from 0 to 2.5 add 20%
price value from 2.51 to 10 add 18%
price value from 10.1 to 20 add 15%
price value from 20.1 and above add 11%
This is why i thought dialog would be good here, but i can also change it in the code each time i execute macro. Hope that`s clear enough.
About the dialog. I havent done it before so it might take a looong time to provide it. Maybe i dont need the dialog, i can change the constant variables in the code manually.
The thing is that the % added to the price always depends on the value of the initial price. Like if price is 0.52 usd i add like 20% to the price but for example if the price is higher like 1000 usd i add only 2% and so on. So each time i run the macro for different sheet i need to set % i add for given price range (or use deflaut). So i need to control two things the price range and % to add. For ex. i set 4 price range and 4 different % to add accordingly:
price value from 0 to 2.5 add 20%
price value from 2.51 to 10 add 18%
price value from 10.1 to 20 add 15%
price value from 20.1 and above add 11%
This is why i thought dialog would be good here, but i can also change it in the code each time i execute macro. Hope that`s clear enough.