How do I create a single template that will process multiple rows of data?

[indie]

I want to do something that is easy to do in Microsoft Access, which I no longer have, but I don't know how to do it in
Excel.

I want to be able to take a rows of data and output them using a single template (not sure of the right word). E.g.: The
data in worksheet 1 is this:

A B C
1 Jim Hart 123 Main Street 123-4567

2 Joe Smith 456 State Street 234-5678

3 John Brown 789 Elm Street 345-6789


How do I create a single template in worksheet 2 that takes the above data and outputs the data arranged like a rolodex card
without having to write (or cut and paste) a template for each row individually? In other words, I just want to create a
single form that takes the data and that will then create as many rolodex cards as there are rows of data.

Thanks for any help.

 

[Anne Troy]

Hi, Indie. Please see my tutorial on just this task:
http://www.officearticles.com/tutorials/an_extreme_tutorial_in_microsoft_excel.htm#boss
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

I want to do something that is easy to do in Microsoft Access, which I no

longer have, but I don't know how to do it in

Excel.

I want to be able to take a rows of data and output them using a single

template (not sure of the right word). E.g.: The

data in worksheet 1 is this:

A B C
1 Jim Hart 123 Main Street 123-4567

2 Joe Smith 456 State Street 234-5678

3 John Brown 789 Elm Street 345-6789


How do I create a single template in worksheet 2 that takes the above data

and outputs the data arranged like a rolodex card

without having to write (or cut and paste) a template for each row

individually? In other words, I just want to create a

single form that takes the data and that will then create as many rolodex

cards as there are rows of data.

 

[Debra Dalgleish]

You can use the Mail Merge feature in Word to print the data in card
format, with your Excel file as the data source. There's information on
the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

And David McRitchie has instructions on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm