Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Info combined from 2 worksheets into a new worksheet

I have created a worksheet that has a place for a student's name and
teacher's name. I have another worksheet with all of the students' names and
teachers' names that need to go into the first worksheet. I would like to do
something that would work kind of like a mail merge that would create a sheet
for each student's name and teacher's name that could be quickly printed.
Any ideas?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Info combined from 2 worksheets into a new worksheet

Maybe you could use the technique at Debra Dalgleish's site:
http://contextures.com/xlForm03.html
and maybe...
http://contextures.com/xlForm02.html

ascottj wrote:

I have created a worksheet that has a place for a student's name and
teacher's name. I have another worksheet with all of the students' names and
teachers' names that need to go into the first worksheet. I would like to do
something that would work kind of like a mail merge that would create a sheet
for each student's name and teacher's name that could be quickly printed.
Any ideas?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Info combined from 2 worksheets into a new worksheet

I'm afraid I've moved outside my realm.... I'm having difficulity wrapping my
brain around what it is all saying.....

"Dave Peterson" wrote:

Maybe you could use the technique at Debra Dalgleish's site:
http://contextures.com/xlForm03.html
and maybe...
http://contextures.com/xlForm02.html

ascottj wrote:

I have created a worksheet that has a place for a student's name and
teacher's name. I have another worksheet with all of the students' names and
teachers' names that need to go into the first worksheet. I would like to do
something that would work kind of like a mail merge that would create a sheet
for each student's name and teacher's name that could be quickly printed.
Any ideas?


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copied info from Excel worksheet, but pasted info won't work in fo KRISTENV Excel Discussion (Misc queries) 3 January 8th 09 03:13 PM
Transfering info from main worksheet to multiple worksheets jeffrey Excel Worksheet Functions 0 February 7th 08 03:32 PM
How use info in Excel shared worksheets to create new worksheets dkc Excel Worksheet Functions 0 June 28th 07 08:36 PM
Creating a log with info from worksheets...... kitkatq Excel Discussion (Misc queries) 0 September 26th 06 06:43 PM
Is it possible to transfer info between worksheets Boenerge Excel Discussion (Misc queries) 0 May 20th 05 07:19 PM


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"