MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help! How do I do this?

Posted by Amber on February 15, 2002 12:07 PM

I am trying to figure out how to make excel (or a macro in excel) look at column d to see if it has "ws*" in it, then if it does-paste "cisco" into column b..... (if it does not have "ws" in the cell then do nothing)..... can someone tell me if, then how to do this?

Posted by Dreamboat on February 15, 2002 12:19 PM

In column B, same row, and supposing we'll start with Row 2:


Posted by Mark W. on February 15, 2002 12:20 PM

AutoFilter column D using Begins with "ws" as
the criteria. Select column B and choose
the Edit | Go To... | Special... Visible cells only.
Type "cisco" and press Control+Enter.