how to programatically do lot of steps

Thanks for your reply.

Pls. tell me what do you mean by "Apply filter to your sheet"... i tried it as this that i press the filter button but nothing happens. Me using Excel 2007.

Originally Posted by Marcol

Have you tried this

Apply a filter to your sheet

With column F

Text filters > Begins with

Show Rows Where:
Begins with:= a

Select the "or" radio button
then in the next 2 fields
Begins with:= A

Select all the resultant rows
Copy and Paste to new sheet