Copy certain cells of rows containing a value in particular cell to new worksheet/workbook

[peartree]

I am new to all of this, so please go easy on me! I'm working hard to learn this stuff but am running out of time on this one.

I have a school fundraiser order form to which values are put into the quantity column. Can I copy and paste the rows in which a quantity is entered into a new sheet or even a new workbook? However, I only want the item name and the quantity columns copied over, not the weights, etc. For example, if I have columns A-G and a quantity is entered into column F, I only want columns A and F copied over. To make it more complicated for me, the form is broken up into different areas which use the columns differently, so I would have to use multiple ranges.

Any help would be greatly appreciated

[mrjinx007]

I am sure there are better ways to do this, see if it works for you.

[peartree]

Thanks for that. I'm trying to expand on it. I was hoping to only show the items that have been ordered. The idea is to create a packing list which doesn't list all the items, just the ones for which a quantity has been entered. I'll keep at it...