Pick ticket

**trsmith** · 02-23-2010, 05:05 PM

Hello Everyone,
I have a excel file A1-AA1 is the header with info. A2-AA2 has the pick qty. I need to make a pick ticket to print per page using the header then the info. I like to have a main page so that is prints nice a big and easy to read. That reads the each row and fills in the info. I have 1000+ pick tickets needed. Thank you everyone who puts anytime into this. Please see attachment

Trsmith

**jasoncw** · 02-23-2010, 09:09 PM

Not sure I quite understand exactly what you need, but try this:

Please Login or Register  to view this content.

HTH,
Jason

**Leith Ross** · 02-23-2010, 10:56 PM

Hello trsmith,

This macro is a little different than Jason's. This will copy over only the values and not the formats. The macro uses arrays to define the cell groups. The advantage to this is the cells to be copied do not have to be sequential order. The downside is it requires more code. This has been added to button on the label worksheet.

Please Login or Register  to view this content.

**trsmith** · 02-24-2010, 11:33 AM

Thanks for your time but I'm still have an issue with both codes when I go to print with Jason I get an error or with Leith I get the Distribution List printed 11 times really small. Any fixes out there. Again thanks for anyone who puts any time into this.

**Huron** · 02-24-2010, 12:20 PM

In Leith Ross's code try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**Leith Ross** · 02-24-2010, 12:37 PM

Hello trsmith,

Have you tried changing the font size of worksheet? The macro only copies the values and does not copy any formatting. It could be that the format was changed by Jason's code when you ran it.