ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Info combined from 2 worksheets into a new worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/216170-info-combined-2-worksheets-into-new-worksheet.html)

ascottj

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?

Dave Peterson

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

ascottj

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



All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com