See if it helps you I did not create separate sheet, u just need to select the students name and it will give you the details.
So no need to create the separate sheets.. Best Regards Momin Siraj Ahmad From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of shashank bhosle Sent: 04 October 2011 10:29 AM To: excel-macros@googlegroups.com Subject: [bulk] $$Excel-Macros$$ Connect 2 sheets ..... Importance: Low 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
Database.xlsx
Description: Database.xlsx
