Thanks mostly to the help that you guys have given me, I'm almost finished with a customer form project that I'm working on. I need help with tweaking my final product:

I have a spreadsheet that I have allowed room for 20 lines of data linked from another sheet. The data includes an item number, quantity and various possible sizes on each line. On the destination sheet, I have a simple formula to total the columns, and then I print the order. The lines of data that are not used are listed and of course showing a "0" in each field. Is there any way to clean this up show that only the lines of data used show up, without having "0" in each cell for each unused line. I can live with what I have, but it would look a lot cleaner when I print the final form.

I hope that I explained this so that you can understand what I'm talking about.

Thanks,

Wendell