Excel question regarding data between spreadsheets

[garbold]

I am running a parts database using excel and have lines of data with amounts alongside.
I wish to bring the data into another spreasheet only if the part has a quantity against it and ignores the parts with no quantity.

This is probably a simple one but it has me foxed!

Thanks

Garbold

 

[WhatTheXL]

Data> Filter > Autofilter
Filter by quantity > 0 or not equal to 0
Ctrl+G > Special > Visible Cells Only
Copy and Paste to the other WS.