Need help with migrating data between sheets

[blainearcher]

I have a workbook with 3 sheets and on sheet 1 I have columns with description, model number, quantity, cost, and total. I've got static entries in all the columns but the quantity and total. Quantity is the number I change based on job requirements and total is a formula. My goal is if I have any number other than a 0 in the quantity column have that whole row copy over to sheet 3 which is a summary sheet and finished quote. Can someone help me with this?

[abduljaleel.mca]

Post a workbook with an example....

[blainearcher]

Here's a small demo workbook

[FDibbins]

You didnt give us much to go on in that file You dont have headings (so we dont know which column is which), your summary sheet is completely empty.

You said "I have any number other than a 0 in the quantity column", well I dont know which column that is, but both F and G only contain 0?

It would help if you provided a few samples of what your expected outcome would look like?

[blainearcher]

Sorry it took me forever to figure out how to attach another example

[FDibbins]

Sorry for the delay in getting back to you

I added a helper column in sheet 1 and used that to ID the data to extract. See if the attached will work for you?

[blainearcher]

This looks exactly what I was looking for. Thanks so much!

I am having trouble merging it into my own workbook. I understand the helper column and that's working fine in my workbook but I'm having trouble getting the data to show up on the Summary sheet. I've copied your formula over and edited for the proper columns for example my helper column is in column K. Still no data being copied over. Is there something running behind the scenes I'm not aware of?

[blainearcher]

A co-worker has fixed my problem. Looks like the formulas needed the column names and I hadn't copied those over.

[FDibbins]

Sorry I didnt reply sooner, i was logged off But Im glad you got it sorted out, and thanks for the feedback