Move row data from one sheet that fits certain criteria to another sheet

Hello, I'm new to the programming aspect of excel so was hoping someone could tell me how to code this sequence.

What I am looking to do is transfer some of the row data from one sheet within an excel workbook to another based on a specific critieria.

I have a tab called "Proposal Summary" and a tab called "Operations Summary" When column G on the tab "Proposal Summary" = "Accepted" I want the data in columns "A", "B", "C", & "H" to move to the same rows/colums on the tab "Operations Summary"

Any suggestions?

Appreciate your help!

sstewar1,

Welcome to the forum. Try the following macro:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar