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

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.

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"indie" <indie@pend.ent> wrote in message
news:XMqdneJrJKlH9UzfRVn-1A@giganews.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.
>
> Thanks for any help.
>

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/MailMe...AMailMerge.htm

And David McRitchie has instructions on his web site:

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


indie wrote:
> 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.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html