Merge Name List Within Excel Spreadsheet

J

JoannieMaj

I'm working on a conference billing where each student will pay
certain amount in fees, plus other assorted charges. I have the billin
form set up in Excel, but want to merge the student's name IN TO th
form.

I tried putting the list of students on the form, and then inserting
page break between each name with the end result that the form woul
print - and a single student's name & class would appear at the botto
of the sheet. For some reason Excel won't put in the page breaks (and
can't view the page breaks because Excel has deemed "Page Break Preview
unnecessary). I know how to use page breaks - they just aren't working
Is the concept flawed - do I have to do this in MS Word and merge th
student list in to THAT? I'd rather have it one package/form! Thanks
 
C

Claus Busch

Hi Joannie,

Am Thu, 31 Oct 2013 16:38:19 +0000 schrieb JoannieMaj:
I tried putting the list of students on the form, and then inserting a
page break between each name with the end result that the form would
print - and a single student's name & class would appear at the bottom
of the sheet. For some reason Excel won't put in the page breaks (and I
can't view the page breaks because Excel has deemed "Page Break Preview"
unnecessary).

have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for workbook "HPageBreaks".
Rightclick and download it because macros are disabled in SkyDrive.
If that would not help, please upload your file and post the link here.


Regards
Claus B.
 
J

JoannieMaj

Hi Claus! I'm going to set up a sample of what I want but this is m
first shot at a SkyDrive account:

https://skydrive.live.com/redir?resid=6F9930B49CDD0171!105

See if that works, it's easier to see it thank explain it.
THANKS!!!!
Joannie

QUOTE=Claus Busch;1614746]Hi Joannie,

have a look:
for workbook "HPageBreaks".
Rightclick and download it because macros are disabled in SkyDrive.
If that would not help, please upload your file and post the link here.


Regards
Claus B.
 
J

JoannieMaj

Well CRAP. I can't open it with any functionality because "Visual Basi
Macros do not work in Excel 2008 for Mac". If I say "open it anyway
there is no functionality. Microsoft makes me absolutely NUT
sometimes.
I'm going to have to mail merge the lists into a MS Word doc, I guess.
Just thought it would be SO NICE to have it all in one tidy littl
sheet!
Thanks so much for your help - you are a superstar!
Joannie


Hi Joannie,

Am Sat, 2 Nov 2013 02:08:55 +0000 schrieb JoannieMaj:
-

please look he
http://tinyurl.com/3s4zwaz
for workbook "FormPrint"
Rightclick and download it because macros are disabled in SkyDrive.
The macro inserts one participant after the other in B10 and prints a
copy for each of them.


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top