Copy Rows to New Sheet Based on Criteria

[MaryD27]

Good Morning!

I'm very new here. I'm working on a project for work and I'm totally stuck.

Here are the details:

I have a very large workbook containing quoting information. There are 28 different sheets representing different vendors. Each sheet contains quote numbers and quote information; the sheets range in size from 50 lines to 4000. The columns are headed as follows:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Job Name[/TD]
[TD]Quote #[/TD]
[TD]Date[/TD]
[TD]Customer[/TD]
[TD]Quote Writer[/TD]
[TD]Quantity[/TD]
[TD]Models[/TD]
[TD]Amount[/TD]
[TD]Comments[/TD]
[TD]Follow-Up[/TD]
[TD]Assigned To[/TD]
[TD]Last Follow-up Date[/TD]
[TD]Status[/TD]
[/TR]
</tbody>[/TABLE]

When jobs are tagged for follow-up, an "X" is entered into the column.

I want a list of all the jobs that have been tagged for follow-up from every sheet. I need all the information (every column within the row) to copy to a new sheet or a new workbook. This will be done on a recurring basis, so I would like to make sure the same information is not duplicated.

I've seen VBA coding online of others trying to accomplish similar things, but I am very new to VBA and having trouble customizing the macros to my needs. If anyone has any codes or even formulas that could help, I really appreciate the input. I'd be happy to clarify anything, if you have questions.

Thanks in advance and Happy Friday!

 

[MaryD27]

Thank you so much, Mumps!!! I just had time to get back to this project. You are a lifesaver!!!

 

[mumps]

You are very welcome.