11-11-2009, 12:00 PM
Hi,
In my work i often have excel sheet with product prices i need to change (add certain % to the price).
How can i make a macro that :
- Search for cells that have numbers in format x.x ; x.xx; x.xxx (price)
- display dialog box with data (x&z)to fill:
if value 0-x1 add z1%
if value x1-x2 add z2%
if value x2-x3 add z3%
if value x3-x4 add z4%
- Compare search results with these conditions and change values accordingly.
If any one could help on this one i`d appreciate it, it`d help my work a lot.
In my work i often have excel sheet with product prices i need to change (add certain % to the price).
How can i make a macro that :
- Search for cells that have numbers in format x.x ; x.xx; x.xxx (price)
- display dialog box with data (x&z)to fill:
if value 0-x1 add z1%
if value x1-x2 add z2%
if value x2-x3 add z3%
if value x3-x4 add z4%
- Compare search results with these conditions and change values accordingly.
If any one could help on this one i`d appreciate it, it`d help my work a lot.