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?
Related:

1 response

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

Similar discussions

Facebook Security Check Preventing Login
huhjehun -
HelpiOS -

1 response
Excel - IF function with multiple words
Nick -
user -

14 responses
Security check preventing log in
Jovydlgr -
Amandabee -

5 responses