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