how to programatically do lot of steps

Hi All,

I have tons of data arranged in spreadsheet. And i need to do various steps to do work on it. I wonder if these steps can be programed in Excel so that they can be executed with a click of a button.

Here is what i do manually.

1. goto column #F.
2. This column contains a text string.
3. Select the entire ROW if the first character of the text string is 'A'.
4. Copy all the selected ROWs and PASTE them in a new spreadsheet.

Any idea if this can be programmed ?

Any help would be greatly appreciated.

-naeemdotcom