Auto Duplicating Worksheets and Insterting Data from Different Worksheet
 

I'm new to VBA ... so feel somewhat dumb. Anyhow, I'm a schoo
counsellor and am building an Excel spreadsheet for our loca
scholarship association meeting. I have exported a tab delimited fil
from our school admin. software and have put it into a "data sheet
with one row per student: Surname, Given Name, Student Number, an
their grades (Course 1, Mark 1; Course 2, Mark 2 ... Course 20, Mar
20).

I have laid out another "personal worksheet" that performs calculation
on the data from the "data" sheet, and allows for the input o
volunteer hours, parental affiliations, etc. I need one of these sheet
for each student. I also set up a range in this new worksheet t
perform calculations on the students grades according to th
scholarship rules (that part is easy). I want the course and grad
information for each student to be entered into the appropriate column
in the script, and to be sorted in descending order of grade.

What I am looking for is a script that will duplicate the "persona
worksheet" for each student, name the worksheet, place the course
grade information in the appropriate cells in the range, and sort. Hav
spent two days on the problem and haven't got anywhere.

Any help greatly appreciated.
Dou

--
Message posted from http://www.ExcelForum.com

Auto Duplicating Worksheets and Insterting Data from Different Worksheet
 

If you want to send me a copy of the workbook with two or three rows of data
in the data sheet and the personal worksheet "template" sheet, I will
provide some code to do what you want.



It is hard to provide anything here since nothing is known about the
personal worksheet as far as specific locations an layout.

--
Regards,
Tom Ogilvy

"doc_in_bc " wrote in message
...
I'm new to VBA ... so feel somewhat dumb. Anyhow, I'm a school
counsellor and am building an Excel spreadsheet for our local
scholarship association meeting. I have exported a tab delimited file
from our school admin. software and have put it into a "data sheet"
with one row per student: Surname, Given Name, Student Number, and
their grades (Course 1, Mark 1; Course 2, Mark 2 ... Course 20, Mark
20).

I have laid out another "personal worksheet" that performs calculations
on the data from the "data" sheet, and allows for the input of
volunteer hours, parental affiliations, etc. I need one of these sheets
for each student. I also set up a range in this new worksheet to
perform calculations on the students grades according to the
scholarship rules (that part is easy). I want the course and grade
information for each student to be entered into the appropriate columns
in the script, and to be sorted in descending order of grade.

What I am looking for is a script that will duplicate the "personal
worksheet" for each student, name the worksheet, place the course &
grade information in the appropriate cells in the range, and sort. Have
spent two days on the problem and haven't got anywhere.

Any help greatly appreciated.
Doug


---
Message posted from http://www.ExcelForum.com/

Auto Duplicating Worksheets and Insterting Data from Different Worksheet
 

Many thanks, Tom.
File's on the way!
Cheers
Dou

--
Message posted from http://www.ExcelForum.com

Auto Duplicating Worksheets and Insterting Data from Different Worksheet
 

Returned.

--
Regards,
Tom Ogilvy

"doc_in_bc " wrote in message
...
Many thanks, Tom.
File's on the way!
Cheers
Doug


---
Message posted from http://www.ExcelForum.com/

Auto Duplicating Worksheets and Insterting Data from Different Worksheet
 

Thanks, Tom!
Works perfectly!
Dou

--
Message posted from http://www.ExcelForum.com