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.
hi,
try this link to get help:
office.microsoft.com/en-us/access/HP051867001033.aspx
this one also may prove to be helpful to you:
www.learnaccessnow.com/chap18c.html
