4,599 online now
238,435 members
Newsletters
Log in or Join now

Fairfax Digital

Essential Baby > General > Miscellaneous

Navigation

Welcome Guest
( Log In | Register )

Quick links

Help

Forum links

Blogs

Today's active topics

Newsletter Subscriptions

Rules

2 Pages

1 2 >

Help! Excel spreadsheet question, *posted here for more traffic

PLARK View Member Profile	07/02/2013, 06:30 PM Post #1
Posts: 513 Joined: 7-October 09
Regular Member
Hi, can anyone help me with this: I would like to create printable vouchers from existing spreadsheet information. Is this at all possible? The only information I have come across is setting and using 'data entry forms' which is ok for new info but doesn't help me for existing information I am googling but not coming up with anything - I may be using the wrong terminology. Same problem with Excel Help function Any help would be really appreciated TIA

CrazySingleMum View Member Profile	07/02/2013, 06:33 PM Post #2
Posts: 4,389 Joined: 6-December 07
We used to stay at home but now we have a social life ..
It sounds like you want to do a merge. It may be easier to set up the voucher in Word and just pull the data from the spreadsheet in Excel.

KT1978 View Member Profile	07/02/2013, 06:33 PM Post #3
Posts: 5,758 Joined: 13-May 06
KT1978
Could you open word, create the voucher and mail merge the other data?

CrazySingleMum View Member Profile	07/02/2013, 06:38 PM Post #4
Posts: 4,389 Joined: 6-December 07
We used to stay at home but now we have a social life ..
QUOTE (KT1978 @ 07/02/2013, 07:33 PM) Could you open word, create the voucher and mail merge the other data? Snap lol

PLARK View Member Profile	07/02/2013, 06:42 PM Post #5
Posts: 513 Joined: 7-October 09
Regular Member
see? I KNEW EB would come to the rescue! And the solution is so darn simple! I feel a bit stupid but very thankful that I have a answer. One more dumb question - can I print multiple, seperate -entry vouchers on one a4 page (eg 6 per page) or should I invest in smaller size sheets for printing (like labels but not sticky) Thanks, EB!

CrazySingleMum View Member Profile	07/02/2013, 06:49 PM Post #6
Posts: 4,389 Joined: 6-December 07
We used to stay at home but now we have a social life ..
You can print multiple vouchers on one sheet, you would need to set a continuous section break between each voucher. I'd offer to help you with it, but I don't have Office on my laptop.

veemattau View Member Profile	07/02/2013, 06:51 PM Post #7
Posts: 508 Joined: 9-September 07
veemattau
You can print multiple personalised vouchers per page .... it would probably be easiest to use the label wizard in word foe the set up, then mail merge and print on plain paper.

PLARK View Member Profile	08/02/2013, 02:57 AM Post #8
Posts: 513 Joined: 7-October 09
Regular Member
thank you CSM & vee - now I have an idea of where to start (I confess I have no idea how to mail merge but I figure I will muddle through )

veggiepatchfamil... veggiepatchfamily View Member Profile	08/02/2013, 03:01 AM Post #9
Posts: 781 Joined: 1-December 08
Regular Member
Sometimes under the printing options you can click on how many pages per sheet, so you can print the one A4 page design up to 8 times (from memory) onto one a4 page printed. Lol if that made any sense

veemattau View Member Profile	08/02/2013, 08:13 AM Post #10
Posts: 508 Joined: 9-September 07
veemattau
You mail merge from word, there is a wizard to help i think.... so you set up your page, labels if it's a fairly simple design, then find the mail merge option in the tabs at the top. It should walk you through where to get your 'source data' from (your spreadsheet), then you tell it where you want each piece of info to go by adding in 'fields' (《name》《address》《code》 etc) to your voucher. Sorry, I hope I'm making sense, it's been a long time since I used office and I'm only on my phone here!

« Next Oldest · Miscellaneous · Next Newest »

2 Pages

1 2 >

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)

0 Members:

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

The accidental attachment parent

"Attachment parenting has set me up for ... well, I'm not going to say failure, but for a very difficult time," says one mum.

Baby love is worth the expense

Amidst all the arguing over which paid parental leave scheme is best for parents, is anyone talking about what's best for babies?

Immunisation, fever and pain relief

Find out the benefits and risks involved with protecting your child from harmful diseases.

Thank You Mum

Send your mum a personalised eCard this Mother?s Day to show her you are thankful and to help us remember the women who face motherhood in situations of great adversity.

Free: 'The First Year' ebook

Check out our new interactive ebook, part of the brand new SMH Shortbooks series, for free!

One mum's 'biggest mistake' offers lesson for all

A mother sparked conversations around the world when she declared, in a national newspaper, that she wished she'd never had her two children. But her story can teach us a valuable lesson on parenthood.

Ask an expert: My child is suddenly resisting toilet training

My child is resisting the toilet training process. We got off to a good start, but now she?s refusing to use the toilet. What can we do now?

Johnson's Baby 'how to' videos

We've learned a lot since we launched our first JOHNSON'S� baby powder way back in 1894, so we've put together this collection of 'how to' videos to get you started on your exciting journey.

New dads are sexy and they know it

While most women wouldn?t associate being a new parent with feeling more attractive, it seems men see it differently: they think they?re better looking than before they were dads.