Jump to content

Help! Excel spreadsheet question
*posted here for more traffic


  • Please log in to reply
11 replies to this topic

#1 KissMyBaht

Posted 07 February 2013 - 06:30 PM

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

#2 FeralCrazyMum

Posted 07 February 2013 - 06:33 PM

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.



#3 KT1978

Posted 07 February 2013 - 06:33 PM

Could you open word, create the voucher and mail merge the other data?

#4 FeralCrazyMum

Posted 07 February 2013 - 06:38 PM

QUOTE (KT1978 @ 07/02/2013, 07:33 PM) <{POST_SNAPBACK}>
Could you open word, create the voucher and mail merge the other data?


Snap lol

#5 KissMyBaht

Posted 07 February 2013 - 06:42 PM

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!

#6 FeralCrazyMum

Posted 07 February 2013 - 06:49 PM

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.



#7 Shiny Star

Posted 07 February 2013 - 06:51 PM

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.

#8 KissMyBaht

Posted 08 February 2013 - 02:57 AM

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

#9 veggiepatchfamily

Posted 08 February 2013 - 03:01 AM

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 original.gif

#10 Shiny Star

Posted 08 February 2013 - 08:13 AM

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!

#11 Shiny Star

Posted 08 February 2013 - 08:13 AM

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!

#12 HGL

Posted 08 February 2013 - 08:21 AM

When you're creating a mail merge with multiple vouchers/labels on one page, there is a 'Next Record' merge field that will help you do the job. The wizard should set it for you but just in case, this is what the field is for so don't delete it.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

 

Exclusive Black Friday Sale!

Get over 40% off selected products, including prams, baby carriers, cloth nappies, sleeping bags and much more! 24 hours only, on May 6 - register now for your special code.

Kelly Clarkson shares first photos of son

Kelly Clarkson has shown off the first photos of her son, Remington Alexander Blackstock.

5 childbirth myths that need to be busted

Birth is an unpredictable, mysterious process that intrigues us all, and there is a lot of misinformation out there.

Mum of three fatally shot by toddler while driving

A US mother has been shot by her toddler while driving on a highway in Wisconsin.

All you need is one minute to work out

The seven-minute-work out is old news. Research shows the effectiveness of going hell-for-leather for just one minute.

Pregnant women needed to join diabetes study

Pregnant woman in country Australia will help Adelaide researchers figure out why cases of type 1 diabetes have doubled over the past two decades.

Just announced: the Mountain Buggy Unirider

It's the perfect solution to combat those toddler meltdowns when they no longer want to be in a pram but can't walk long distances.

Authorities euthanise dog that fatally bit a newborn baby

A pit bull mix that fatally bit a 3-day-old infant last week has been euthanised, authorities said.

The push for Medicare to fund lactation consultants

While meeting with a lactation consultant can make an enormous difference to a new mother, it's not a service that is available through the public health system.

Why it's perfectly natural to dislike other people's children

Members of a popular forum are fiercely debating whether it is acceptable to dislike a friend's child.

Woman gives birth on plane, names baby after airline

A pregnant woman who unexpectedly gave birth on a flight has named her new baby after the airline, Jetstar.

Heartwarming photos show the joy of adoption after foster care

Children living in foster care can feel like their future is less than clear. But that uncertainty disappears the day they are adopted by their "forever family" 

'Oh my god, it's a baby!' Mum shocked to give birth

When the cramps started to kick in, Klara Dollan just assumed a painful period was starting.

Mum's Facebook plea: 'Help me find my daughter's father'

Kerryn has a unusual present planned for daughter Imi's 13th birthday celebrations - she hopes to be able to be able to give the soon-to-be the teenager her first ever photo of her dad.

Is it possible for your house to be too clean?

Our houses are cleaner than ever before. But how clean is too clean? Could a sterile home be putting your family's health at risk?

Millions of Monkeys: puzzles that grow with your toddler

Here's a puzzle that grows with them; the Puzzle Grow Pack by Millions of Monkeys.

Baby names from Britpop

If you grew up in the 90s you might want to look to the genre of Britpop music for baby name inspiration.

What to eat and drink when you have gastro

When you catch a bug that causes acute infectious gastroenteritis (gastro), your stomach and intestinal tract become inflamed, causing diarrhoea, nausea, vomiting, abdominal cramping and pain. The last thing you probably feel like doing is eating.

'To this day, I owe her my life'

Would I have survived if I hadn't crossed that street?

Why baby Sonny needs you to vaccinate your children

Caitlin is a firm believer in the importance of immunisation to protect children from harmful and deadly diseases.

Five-year-old's photo captures beauty of motherhood

There is no make-up or special outfits and hairdos, but the five-year-old boy who took this picture captured the essence of motherhood as well as any professional photographer.

Babies know whether you are naughty or nice

Studies have shown that infants in the first months of life try to avoid dealing with social wrongdoers - for example, sharing less with them and helping them less - and they expect others to, too.

 
Advertisement
 

Top 5 Articles

Advertisement
 
 
 

What's hot on EB

The babies who are one in 70 million

Bethani Webb was excited to find out she was pregnant, but the first time mum did not realise she was carrying four babies not one.

Exclusive Black Friday Sale!

Get over 40% off selected products, including prams, baby carriers, cloth nappies, sleeping bags and much more! 24 hours only, on May 6 - register now for your special code.

Cafe offers breastfeeding mums a free cup of tea

A Sydney cafe is offering breastfeeding mums free cups of tea in a bid to show support for the right of women to nurse their babies wherever they choose.

To snip or not to snip? When the decision is not clear cut

Jamie Oliver, who considered a vasectomy, is to be a father again. A fellow dad reflects on his own decision 11 years ago

Doctors stunned by rare twins born almost six weeks apart

To everyone's surprise, Kristen Miller "kept doing better each day", keeping her second baby safe.

Baby book ideas for modern parents

Before my son was born I was given a lovely baby book full of blank pages waiting to be filled with weights and heights and first words.

The adorable smile of a baby seeing his mum clearly for the first time

There is no doubt seeing their child smile for the first time is an unforgettable moment for parents everywhere.

Mum tells how toddler 'nearly hung himself' in cot mishap

When Alison Johnson put her 18-month-old Caleb down for a nap, she had no reason to believe her son was in any danger.

Babies are still switched at birth? Yes, it can happen

All my panic and tears aside, my biggest question looking back is about the kind of security measures used in the maternity ward.

Doctors slammed for taking selfie with newborn

Everyone who visits a mum in hospital in the days following childbirth wants to get a photo with the new baby.

ergoPouch Twosie Sleepsuit for winter breastfeeding

Finally, there's a way to keep warm while breastfeeding through winter.

Health check: How long does sex 'normally' last?

What to do with this information? My advice would be to try not to think about it during the throes of passion.

When breastfeeding sucks: fixing common problems

From niplash to tight boobs, biting to milk supply issues, Pinky McKay looks at common breastfeeding issues and how to solve them.

10 things I've learnt in my first six months with twins

Six months on we're all still alive, and the more we get to know each other the easier the days become.

Mum's loving kiss leaves baby fighting for life

Kirsty Carrington thought nothing of giving her newborn son a kiss, little did she know it would leave the baby fighting for life.

When doing chores is your new 'me time'

After children, 'me time' looks a little different.

Get going: 14 travel strollers for families on the move

A stroller can make or break travelling with a baby or toddler. Here are 15 great single travel stroller options.

10 ways toddlers are terrific

It always pays to remind yourself of how terrific toddlers can be - they're little like this for such a short time

 

ENTER NOW

Do your kids love bananas?

This is the comp for you! We have $800 worth of Myer gift cards and boxes of Australian Bananas to be won. Entry is simple: just post a pic of your little one enjoying a banana in the comments of the FB post to enter.

 
Advertisement
 
 
Essential Baby and Essential Kids is the place to find parenting information and parenting support relating to conception, pregnancy, birth, babies, toddlers, kids, maternity, family budgeting, family travel, nutrition and wellbeing, family entertainment, kids entertainment, tips for the family home, child-friendly recipes and parenting. Try our pregnancy due date calculator to determine your due date, or our ovulation calculator to predict ovulation and your fertile period. Our pregnancy week by week guide shows your baby's stages of development. Access our very active mum's discussion groups in the Essential Baby forums or the Essential Kids forums to talk to mums about conception, pregnancy, birth, babies, toddlers, kids and parenting lifestyle. Essential Baby also offers a baby names database of more than 22,000 baby names, popular baby names, boys' names, girls' names and baby names advice in our baby names forum. Essential Kids features a range of free printable worksheets for kids from preschool years through to primary school years. For the latest baby clothes, maternity clothes, maternity accessories, toddler products, kids toys and kids clothing, breastfeeding and other parenting resources, check out Essential Baby and Essential Kids.