if a number is greater than zero then unhide the line

V

Van Merrill

I want to have a data input sheet and a sales order sheet. Both Sheets would be in the same workbook. The data input sheet would list in the first column the quanity of a specific product and the second column would list the apprpriate model numberand the third column would be the description of the product. I would like to link these cells to the matching cells in the sales order sheet. All the poduct lines would be hiddden in the sales order sheet until a quanity greater than zero would be entered in the matching data input sheet. In other words, the sales order would be blank until someone enters a number greater than zero in the datainput sheet for a particular product which would cause the apprpriate line to unhide in the sales order and we can then print the sales order. Thank you so much in advance for your help!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top