Creating new excel docs with links

S

Shinra14

Hello,

I was wondering if I can do the below with links in excel:

I want to create an application that will read an excel file that contains
the names of students in a course and creates a new excel file for each of
the students based on the source file. The name of each new excel file should
be the name of the student. I know I can create new worksheet and then link
the cells between the source file and the new file. However, can I somehow
have the link create a brand new excel file with the name of the contents of
the cell the link is in? For example, if I have a cell in a source file with
the name Paul. Can I have a link here that creates an all new excel file with
Paul as it’s name?

Thank You,
 
S

Shinra14

Hello,


Those examples definitely help. I was wondering if there was any way to
automate this process. Say I have a worksheet with 2 rows that have the names
Paul and John. Can I run the macro so that it would find the all the names of
the students (if I have 50 students) and then create a new worksheet for each
student so 50 new worksheets?

Thank You,
 
Top