Select next empty cell in column, if data in another column meets criteria

Hello,

I am looking for help writing a macro that would auto run, anytime column A in Sheet 1 gets updated.
I would like the Macro to perform the following:

• If the last cell with data in Column A = 'abc' then select next empty cell in column C
  OR
• If the last cell with data in Column A = 'efg' then select next empty cell in column D

Thank you for help in advance.
Kanuck

try this
im guessing column C and D are not empty columns

Please Login or Register  to view this content.

exactly what I needed thank you k1drock

bakerman's code is more efficient i would suggest you use his code

Thank you both, very appreciative -- both work great but yes will use bakerman2's