I have created 3 different Excel documents that are linked together. I have
created these files to feed into an Excel document that is my student's
gradecards. I would like to be able to make it a little easier for my
collegues to use by "making it into a program" where they can easily
manipulate their data since it is heavily linked. Right now we type our
childrens' scores into one excel file, and then they are sent to another file
that houses each grade card for each student in seperate worksheets. How can
I create something to compile charts that are not a part of the actual Excel
file in which the data is being pulled? (I already have charts in the file,
but we want to be able to compile a chart with the click of one button, sort
data without fear of messing with the links. Please help!