how to programatically do lot of steps

Once again thanks for your reply.

Pls. help me to do these kind of steps programatically. I am more interested in VBA code for this.

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