Hello Excel Gurus,

Need small favour from experts,
I have two columns in Excel, I need a macro, where if Column A contains
value as "Step", column B should populate "Complete".
If column A contains VP, Column B should populate "Pass".


   Step
 Complete
 VP
 Pass
 Step
 Complete
 VP
 Pass
 VP
 Pass
 Step
 Complete
 VP
 Not Run
 Step
 Not Run
 VP
 Not Run
 VP
 Not Run
 Step
 Not Run
 VP
 Not Run


Your help is highy appreciated.


cheers
Kamal

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to