I'm trying to create one consolidated list of material into a delivery list. I have a number of sheets with stock data in. Ie Description (A), Qty (B), Cost (C). up to 1000 rows. I would like to create a new sheet just with the data from rows with a qty in the qty cell (Ignoring blanks), but also taking over Description coloum as well. Any help is much appreciated!!!!