creating new work sheet from data entered in a column

Originally Posted by arlu1201

So which items would go into which sheet? Or would you be entering the values in the 1st sheet, entering the number and then click a button (maybe) which will copy those contents to a new sheet naming it by the value in C1?

Yes correct, new sheet naming it with the value in C1. Entire Rows which have a value in the Qty column (D3-D59) will be copied across into the new sheet.

Sorry if I am not explaining this to well?

Cheers!
Glenn