price ticket template

[Michael Higgins]

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)...........

 

[Michael Higgins]

oops it was in some kind of order when i typed it.

 

[Gord Dibben]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP