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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks