Copy Specific Range

I'm sure this will be very easy for you vba experts.

All I'm trying to do is select,copy and paste all the values in the "A" column that start with the letter "A" to another sheet in the same workbook.

Have a go at this. I've attached example as well.

Please Login or Register  to view this content.

This is good.I'm sorry I didn't say this when I first posted.I don't know what I was thinking.I need to copy the cell that begins with the letter "A" along with the row that it is on,up to the G column.
For example if cell A2 begins with the letter A,I want to copy A2,B2,C2,...G2 and paste that data starting at cell B6 on another sheet.
But thank you so much for replying to my post.You are awesome.

I'm not sure what you mean can you upload a spreassheet with an example.

Cheers

Tom

I attached an image file to try to illustrate what I mean.

Sorted It

Cheers

Tom

Thank you Tom Moston.This script is absolutely excellent.You have helped me immensely.Have a great rest of the day.