I have uploaded a sample of a table I am using to track Cookie Orders. Since there are hundreds of orders on the final sheet, I wanted to be able to print a list of each customer, and what they ordered so I can print labels to put on each box.
So I would like to see:
Customer A..1 box of Thin Mints, and 2 Boxes of Tagalongs, etc. (Girl Scout Cookies as you can tell!)
Is there a way to do this?
Thanks for your help.
Do you know what type of label set up you are going to use? it will make a difference in your options. You could have each row link to another sheet that is already formatted to print on your labels.
I guess I was just thinking of address Labels like 5160. But even if I can just get them to print on paper, I could tape them on there. My biggest problem is to just list each customer and their order.
Thanks for replying!!
You could use Word's mail merge to print the labels, with your spreadsheet as the data file. To make it work you would need to make a minor change to your spreadsheet layout so that the column heading "Name" appears on the same row as the cookie names, preferrably in the first row. These headings are then the field names used by Word to extract the data onto the labels.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks