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

  • Thread starter Thread starter indie
  • Start date Start date
I

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


indie said:
I want to do something that is easy to do in Microsoft Access, which I no
Click to expand...
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
Click to expand...
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
Click to expand...
and outputs the data arranged like a rolodex card
without having to write (or cut and paste) a template for each row
Click to expand...
individually? In other words, I just want to create a
single form that takes the data and that will then create as many rolodex
Click to expand...
cards as there are rows of data.
 
Back
Top