Searching for cells that contain a specific text constellation

[Cinema]

Hi,

I want to write a code that searches (In Workbook 2, Sheet1) for cells that cointain a specific text constellation:
If the cells in the first row have the text constellation "TRS..some words... x ..some words..." where x is the Header of each column in Workbook 1 (Sheet 1) and varies from column to column, then the whole column should be copied and pasted below the headers in Workbook 1 Sheet 1. The headers are in the Second Row in Workbook 1 Sheet 1.


Does someone know how to do this?

[Kenneth Hobs]

Would wb1 and wp2 be open already? If you attach a short example of each, helping will be that much easier and on target.

[Paul_Hossler]

Is this different from ...


http://www.vbaexpress.com/forum/showthread.php?57073-How-to-search-a-specific-text-constellation