Previous Topic Next Topic

Macro to check conditions in two columns

Closed
bezi - Feb 16, 2009 at 12:12 PM
rine012
Posts
6
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
 - Feb 17, 2009 at 04:38 AM
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

Answer 1 / 1
rine012
Posts
6
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
May 8, 2009
 12
Feb 17, 2009 at 04:38 AM
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
0