Extract Data From another sheet using VBA

[Joy C]

I have a data sheet in a workbook which I need to extract all the rows where Col G is equal to "Y" and insert the adjacent Cells (Cols A:F) into another sheet.

Is there a piece of VBA code that can do this please?

Many thanks

[MarvinP]

Hi Joy and welcome to the forum.

Could you sort your data using col G and then copy and paste the group of rows from col A to F to your new sheet?

This might be easier than using VBA. For a VBA solution we would really need a sample workbook to write code behind. You need to click on "Go Advanced" and use the paperclip icon above the message to attach a sample file.