How to extract selective rows from a single column of one Sheet to another Sheet

[devnarah]

Hi Gurus,

I have uploaded a sample file for your expert and quick solution.

I would like to extract selective rows from a column in One Sheet to a new Worksheet.



Thanks in advance for the propmt solution.


Regards
Deva

[martindwilson]

in master sheet put these in d2:d6
=ISNUMBER(SEARCH("File name:",B2))
=ISNUMBER(SEARCH("File id:",B2))
=ISNUMBER(SEARCH("sample id:",B2))
=ISNUMBER(SEARCH("comment 2:",B2))
=ISNUMBER(SEARCH("volume:",B2))
now go to combined sheet
select advanced filter to bring up the advanced filter window
put cursor in list range field
click on master sheet and select col a: b
so it says
Master!$A:$B
click criteria range it will swich back to sheet combined so select master sheet again and select d1:d6 so criteria range looks like
Master!$D$1:$D$6
now click copy to another location
focus will switch to sheet combined!
now in copy to: select cell A1
it will then say
Combined!$A$1
click finish