To who ever can help me on this, thank you!
With that said, here is the problem I'm having. I have a beverage sheet for ordering at work. It has the name of the items and then I have to go in and fill out the pages at the bottom. Eventually printing out 6 pages when really I was hoping to consolidate it from a validation list, or pick from list. So that the items I'm ordering are the only ones printed or shown.
I've tried validation etc, but what I'm looking for is that were the names are currently be blank and each line lets me chose from a drop down list. Accordingly though I wanted to have the rest of the row fill in with the appropriate information for that alcohol... being the size and price.
I've tried moving the items off the list to the right in an area that's out side of the printable area, but to no avail.
Is this possible? I'm trying to save us on some paper, and only print one page. At work we only have office 2000, but at my home I have 2003, 2007.
http://www.wonderliver.com/dl/Bev_template.xls
With that said, here is the problem I'm having. I have a beverage sheet for ordering at work. It has the name of the items and then I have to go in and fill out the pages at the bottom. Eventually printing out 6 pages when really I was hoping to consolidate it from a validation list, or pick from list. So that the items I'm ordering are the only ones printed or shown.
I've tried validation etc, but what I'm looking for is that were the names are currently be blank and each line lets me chose from a drop down list. Accordingly though I wanted to have the rest of the row fill in with the appropriate information for that alcohol... being the size and price.
I've tried moving the items off the list to the right in an area that's out side of the printable area, but to no avail.
Is this possible? I'm trying to save us on some paper, and only print one page. At work we only have office 2000, but at my home I have 2003, 2007.
http://www.wonderliver.com/dl/Bev_template.xls