ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   printing a receipt for eack row (https://www.excelbanter.com/excel-programming/333770-printing-receipt-eack-row.html)

DFRITO

printing a receipt for eack row
 
I have a list of students and their address with also what they want to buy,
like a shirt or a duffel bag, and the end of each row or student, how can i
make excel print a receipt or some type of acknowledgment of what they
bought. I was thinking that the recipt can have their name, address, and what
they bought, foe each student or row?

Help!

Anne Troy[_2_]

printing a receipt for eack row
 
If you only need to do it per row, you could easily do a mail merge.
http://www.officearticles.com/word/m...osoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"DFRITO" wrote in message
...
I have a list of students and their address with also what they want to

buy,
like a shirt or a duffel bag, and the end of each row or student, how can

i
make excel print a receipt or some type of acknowledgment of what they
bought. I was thinking that the recipt can have their name, address, and

what
they bought, foe each student or row?

Help!




DFRITO

printing a receipt for eack row
 
I will give it a try, but i would like to stay in excel if possible, the
receipt would need to look like:

student name
address
C,S,Z

Items bought:
Shirt: 1 XL
BookBag: 1

Paid: $0.00


I do appreciate the help, i will try your idea.

Daryl

"Anne Troy" wrote:

If you only need to do it per row, you could easily do a mail merge.
http://www.officearticles.com/word/m...osoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"DFRITO" wrote in message
...
I have a list of students and their address with also what they want to

buy,
like a shirt or a duffel bag, and the end of each row or student, how can

i
make excel print a receipt or some type of acknowledgment of what they
bought. I was thinking that the recipt can have their name, address, and

what
they bought, foe each student or row?

Help!





Tushar Mehta

printing a receipt for eack row
 
Going with Word and mail merge is a way to do what you want with the
minumum fuss -- and no programming. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I will give it a try, but i would like to stay in excel if possible, the
receipt would need to look like:

student name
address
C,S,Z

Items bought:
Shirt: 1 XL
BookBag: 1

Paid: $0.00


I do appreciate the help, i will try your idea.

Daryl

"Anne Troy" wrote:

If you only need to do it per row, you could easily do a mail merge.
http://www.officearticles.com/word/m...osoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"DFRITO" wrote in message
...
I have a list of students and their address with also what they want to

buy,
like a shirt or a duffel bag, and the end of each row or student, how can

i
make excel print a receipt or some type of acknowledgment of what they
bought. I was thinking that the recipt can have their name, address, and

what
they bought, foe each student or row?

Help!







All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com