Macro to check conditions in two columns

[Closed]
Report
-
Posts
6
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
-
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?

1 reply

Posts
6
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
12
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