Search : in
By :

Macro to check conditions in two columns

Last answer on Feb 17, 2009 9:38:34 am GMT bezi, on Feb 16, 2009 5:12:42 pm GMT 
 Report this message to moderators

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

Best answers for « Macro to check conditions in two columns » in :
Excel - Extract identical cells of 2 columns Show Excel - Extract identical cells of 2 columns Issue Solution Note Issue Hello, Got a list of words in column A Got a list of words in column B I am looking for a formula that will produce in column C a list of the words that...
How do I find Word's keyboard shortcuts? ShowHow do I find Word's keyboard shortcuts? To deal with shotcuts you have several possibilities. 1- Some keyboard shortcuts are listed next to the items in the main menu (just open menu list and check out). 2- You can also find...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Check compatibility of a game online ShowCheck compatibility of a game online If you are wondering if a game would run on your PC. It will take some time to determine if (checking all the settings) to see if your configuration is optimal, average, or even sufficient to run the...

1

 rine012, on Feb 17, 2009 9:38:34 am GMT

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

Reply to rine012