Copy Specific Data

[rock_001]

Hi,

I have a very large amount of data in Sheet1, I want to copy all the rows where column "A" begins with "Sort By:" and this needs to be pasted in Sheet2 of the same workbook.

The data will be around 8000 rows out of which about 3000 begins with "Sort By:".

Its actually a paragraph in "column A" that begins with "Sort By:"

Your help is appreciated..

 

[Gary McMaster]

Custom auto filter? Begins with & Sort By: for the parameter

Gary