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
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]3x5[/TD]
[TD]4x6[/TD]
[TD]8x10[/TD]
[TD]11x14[/TD]
[/TR]
[TR]
[TD]Picture 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 5[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Picture 8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]3x5[/TD]
[TD]4x6[/TD]
[TD]8x10[/TD]
[TD]11x14[/TD]
[/TR]
[TR]
[TD]Picture 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 3[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 5[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Picture 8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Picture 9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks so much for your help
Roberta