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:

Job Name

Quote #

Date

Customer

Quote Writer

Quantity

Models

Amount

Comments

Follow-Up

Assigned To

Last Follow-up Date

Status

<tbody>
</tbody>

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.