Macro to extract data where there are 2 leading asterisks

[Howardc1001]

I have data on sheet "raw data". Where the text in Col "A" has 2 leading asterisks, then I want to copy this data in Col A from row 6 onwards up to Col C to sheet "Extracted data" from row 2 onwards


I have manually copied the data to show you what I am trying to achieve



I am looking for a macro to copy and paste the data as per my requirement above


Your assistance regarding the above is most appreciated

[jindon]

Please Login or Register  to view this content.

[gue2013]

Please Login or Register  to view this content.

cheers

[Howardc1001]

thanks for your help, much appreciated

[jindon]

You are welcome and thaks for the rep.
Here's another one which actually does Copy/Paste,

Please Login or Register  to view this content.