It seems to me that, depending on the amount of data per student, that you could have one file with the data for each student in columns and then make a report in the same file for each student as needed. See simple sample
From: shashank bhosle
Sent: Wednesday, October 05, 2011 12:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Connect 2 sheets .....
Hello Dguillett, Momin Siraj Ahmed,
Thank you very very much for giving your valuable time to solve my querry.I
can't express my self to thank to you.
you guys are so talented, even i feel like solving the querries, but i dont
have such a knowledge as you people have.
One more request to you that i need to make a separate dossier for each student
that is appx 125 students . I need to make a separate profile for each student
so i have to make a one workbook for one student which will included 7-8 sheet
showing their different performance record. And as i will have more than 100
sheets i have to give them a name which i can easy find their respective name.
So i had named their sheets as ASE Dossier_RAM.
Please help me guys and please tell me how you learned to write the macros??
please .....
From: dguillett1 <dguille...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Tuesday, 4 October 2011 7:20 PM
Subject: Re: $$Excel-Macros$$ Connect 2 sheets .....
The attached will do as desired to make a sheet for each student. I see no
reason to make a file for each. I also did a print setup.
Option Explicit
Sub makesheetforeachSAS()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row)
Sheets("Template").Copy after:=Sheets("Database")
ActiveSheet.Name = c
c.Offset(, 1).Resize(, 10).Copy
Range("d3").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Range("a1").Value = c
Next c
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub
From: shashank bhosle
Sent: Tuesday, October 04, 2011 1:28 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Connect 2 sheets .....
Dear Friends,
I have two files
1. ASE Dossier_RAM
2. ASE Dossier_SHAM
2. Database
I want to extract the information of every student e.g Ram from database and
make a separate sheet of Dossier of every Student.
In Database the information is according to Columns. When pasting it into
Dossier file I want it to be transposed.
I have more than 100 student and needs to make their different spread sheet of
and Name it accordingly as per their name.
I am trying but I am not getting accurate results Please suggest some macros.
can it be automated for rest of the students?
Please help
2 manual spreadsheets are attached as example for your reference
Regards
Shank
9422927499
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
students.xls
Description: MS-Excel spreadsheet
