Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)........... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)........... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)........... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am looking for a template for a professional looking price book | Excel Discussion (Misc queries) | |||
Compare house plans to price/square footage, what template to use? | Excel Discussion (Misc queries) | |||
ticket counting | Excel Worksheet Functions | |||
Looking for Buy/Sell Stock or Futures order ticket template? | Excel Discussion (Misc queries) | |||
How do I print pages 2 & 3 with the Price Sheet template? | Excel Worksheet Functions |