price ticket template
 

Hi, Is there a bit of code that will allow me to create printable tickets
using the relevent details held on a worksheet I have worked in shops where
they print out say 500 new price tickets and i can only guess they have been
generated via a database.

as an example I have done the following price list.


Many thanks.
Michael

A B C
D E F

1 PRODUCT
2 VER1 169 NA
199 249 NA
3 VER2 249 NA
319 409 NA
4 VER3 279 NA
389 469 NA


FINISHED ITEM


COMPANY LOGO

PRODUCT TITLE (FROM A1)



VERSION 1 (FROM A2)


also available
ver1 (from B2) ver1 (from C2) ver1 (from D2) ..........

ver2 (from C2) ver1 (from C3) ver1 (from D3)...........

ver3 (from D2) ver1 (from D3) ver1 (from D4)...........

price ticket template
 

oops it was in some kind of order when i typed it.
:-)
"Michael Higgins" wrote in message
om...
Hi, Is there a bit of code that will allow me to create printable tickets
using the relevent details held on a worksheet I have worked in shops
where they print out say 500 new price tickets and i can only guess they
have been generated via a database.

as an example I have done the following price list.


Many thanks.
Michael

A B C D
E F

1 PRODUCT
2 VER1 169 NA 199
249 NA
3 VER2 249 NA 319
409 NA
4 VER3 279 NA 389
469 NA


FINISHED ITEM


COMPANY LOGO

PRODUCT TITLE (FROM A1)



VERSION 1 (FROM A2)


also available
ver1 (from B2) ver1 (from C2) ver1 (from D2) ..........

ver2 (from C2) ver1 (from C3) ver1 (from D3)...........

ver3 (from D2) ver1 (from D3) ver1 (from D4)...........

price ticket template
 

Excel alone is poorly suited for creating labels or tickets.

Do you have Word?

Use Word's mailmerge with Excel or Access as the data source.

Assuming you are using Word for the mailmerge and Excel for the source see these
sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP


On Sun, 22 Jun 2008 18:21:40 GMT, "Michael Higgins"
wrote:

Hi, Is there a bit of code that will allow me to create printable tickets
using the relevent details held on a worksheet I have worked in shops where
they print out say 500 new price tickets and i can only guess they have been
generated via a database.

as an example I have done the following price list.


Many thanks.
Michael

A B C
D E F

1 PRODUCT
2 VER1 169 NA
199 249 NA
3 VER2 249 NA
319 409 NA
4 VER3 279 NA
389 469 NA


FINISHED ITEM


COMPANY LOGO

PRODUCT TITLE (FROM A1)



VERSION 1 (FROM A2)


also available
ver1 (from B2) ver1 (from C2) ver1 (from D2) ..........

ver2 (from C2) ver1 (from C3) ver1 (from D3)...........

ver3 (from D2) ver1 (from D3) ver1 (from D4)...........