Roberta001
New Member
- Joined
- Mar 9, 2017
- Messages
- 10
Using Excel 2010 and I need to create a spreadsheet that will be changing weekly...like an order form.
In column A I will have a list of products. In row 1 I will have different sizes available. I only want to print what needs to be ordered. For example: In the workbook I will have separate sheets that will transfer to the main ordering page. Is there a way to set this up permanently so that when I go to print it automatically know to print only the rows that have an order quantity. So in this example it would only print Picture 3, 5 and 7?
Thanks so much for any help
Roberta
<tbody>
</tbody>
Thanks so much for your help
Roberta
In column A I will have a list of products. In row 1 I will have different sizes available. I only want to print what needs to be ordered. For example: In the workbook I will have separate sheets that will transfer to the main ordering page. Is there a way to set this up permanently so that when I go to print it automatically know to print only the rows that have an order quantity. So in this example it would only print Picture 3, 5 and 7?
Thanks so much for any help
Roberta
3x5 | 4x6 | 8x10 | 11x14 | |
Picture 1 | ||||
Picture 2 | ||||
Picture 3 | 2 | |||
Picture 4 | ||||
Picture 5 | 5 | |||
Picture 6 | ||||
Picture 7 | 10 | |||
Picture 8 | ||||
Picture 9 |
<tbody>
</tbody>
Thanks so much for your help
Roberta