chart or macro problem

M

mcgrath383

hi
problem: Have around 300 student records want to produce a chart for
each one, the chart contains 4 pieces of data for each student and is
unique to each student, I want to produce a seperate excel template for

each student e.g. i will end up with 300 seperate excel files prefably

called the students name??
any help would be gratefully received
cheers
paddy
 
D

Don Guillett

Probably not necessary. Depending on your setup you could probably have a
database all the info with a double click event to display the chart for the
clicked student.
student data1 data2 data3 data4
a 1 2 3 4
 
M

mcgrath383

hi don
sorry for multiposting just need to try and get this sorted, thank you
for your repsonse, however my skills on access are limited or can i
create a database in excel
thanks
paddy
 
M

mcgrath383

hi don
thanks for that not sure how to do that to be honest, i have created a
template that I want the data to be cut and pasted from the other
worksheet, i am currently trying to create a macro that will copy and
paste relevant info from the worksheet to the template e.g. name,
surname ks2 data and current.
I can get a macro to do this however I cant tell it to go to the next
student e.g. row 3 so i can get a seperate file for each student? can
you help?
thanks
paddy
 
Top