If row contains a string copy that row and add string text to cells in it.

**Vestax159** · 01-17-2010, 02:55 PM

So heres what I need to do. Search a column to see if it contains a string say "ItemA" anywhere in that cell. If it does then copy that row into a new row and add that string to several cells in the new row.

Please Login or Register  to view this content.

Thnx in advance for the help!

**shg** · 01-17-2010, 03:53 PM

An example workbook would help.

**Vestax159** · 01-17-2010, 08:09 PM

Sure

Please Login or Register  to view this content.

So basically do the above.

**pike** · 01-17-2010, 10:15 PM

adapt this regular

Please Login or Register  to view this content.

If row contains a string copy that row and add string text to cells in it.

LinkBack

Thread Tools

Rate This Thread

Display

If row contains a string copy that row and add string text to cells in it.

Re: If row contains a string copy that row and add string text to cells in it.

Re: If row contains a string copy that row and add string text to cells in it.

Re: If row contains a string copy that row and add string text to cells in it.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions