Hello,
I am trying to update prices in excel spreadsheet. I have three different Unit of measures (Each, Pack, Case), I need a macro that will check the Unit of Measure in one column and update the price accordingly.
E.g
Boric acid (Case of 10)
Acetone (Package of 5)
Beaker (Sold by Each)
I want this macro to check this column and if it finds case then update the prices accordingly.
Can you help?
Configuration: Windows XP Internet Explorer 7.0