View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Higgins Michael Higgins is offline
external usenet poster
 
Posts: 8
Default 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)...........