Cinema
09-05-2016, 05:59 AM
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?
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?