Dear All masters, I am having some data like below:- Is there any formula or Vba code to fetch or copy entire column based on text found. Many many thanks in advance.
From this data I need to copy only that entire column in which the word "ANDE" is found and paste the entire row as below in another sheet:-
It it fixed that the word which I have to search will be unique, but it is not fixed that the word which I will search will be in same column, every time it will be changing the position from cell to cell and column to column.
But the given range of data will be fixed.
Many many thanks in advance. if any one can help on this.
| Column | A | B | C | D | E | F | G |
| Row 1 | Days | D1 | D2 | D3 | D4 | D5 | D6 |
| Row 2 | type | PH1 | PH2 | PH3 | PH4 | PH5 | PH6 |
| Row 3 | jk | ||||||
| Row 4 | lm | ||||||
| Row 5 | |||||||
| Row 6 | no | ||||||
| Row 7 | |||||||
| Row 8 | 08:30 Ande | ||||||
| Row 9 | |||||||
| Row 10 | 789pq | ||||||
| Row 11 | 89yy |
From this data I need to copy only that entire column in which the word "ANDE" is found and paste the entire row as below in another sheet:-
It it fixed that the word which I have to search will be unique, but it is not fixed that the word which I will search will be in same column, every time it will be changing the position from cell to cell and column to column.
But the given range of data will be fixed.
Many many thanks in advance. if any one can help on this.
