S
static69
hello. I have a fairly simple set up for keeping track of test score
for my students. we input their names and all their scores on on
sheet; this gives us their averages that are used to determine if the
receive a satisfactory, superior, or unsat. rating. on sheet two, th
names are inputted automatically from sheet one where they need to go.
The ratings are put where they need to go automatically also. For eac
rating we have to have a bullet explaining why. I have created hundre
of these and they are in lists on sheets 3,4,5. I use a drop box t
choose a bullet, excell pulls it off the list so it cant be use mor
than once. This makes my job and the job of the other instructors muc
easier and saves lots of time writing all this stuff up. The proble
lis in that not all of them are computer savvy, and when they try t
play with the system, they delete row that should not be. They do thi
because we have to transfer all theinfo to word to email it to th
academic records section. They take all the bullets from all th
companies and create the evaluation forms our bullets.
I want to be able to have word act like my sheet does. When the
change an object from excel it will change automatically in the wor
document as well. This way there is no need to try and change th
appearce of the excel sheet to paste to word. Is this possible, an
am I going the wrong way about doing this? There is always a smarte
way. Whatcha got for me. (PS You guys/gals are the best help I got.
My IT guy looks at me like im stupid.
for my students. we input their names and all their scores on on
sheet; this gives us their averages that are used to determine if the
receive a satisfactory, superior, or unsat. rating. on sheet two, th
names are inputted automatically from sheet one where they need to go.
The ratings are put where they need to go automatically also. For eac
rating we have to have a bullet explaining why. I have created hundre
of these and they are in lists on sheets 3,4,5. I use a drop box t
choose a bullet, excell pulls it off the list so it cant be use mor
than once. This makes my job and the job of the other instructors muc
easier and saves lots of time writing all this stuff up. The proble
lis in that not all of them are computer savvy, and when they try t
play with the system, they delete row that should not be. They do thi
because we have to transfer all theinfo to word to email it to th
academic records section. They take all the bullets from all th
companies and create the evaluation forms our bullets.
I want to be able to have word act like my sheet does. When the
change an object from excel it will change automatically in the wor
document as well. This way there is no need to try and change th
appearce of the excel sheet to paste to word. Is this possible, an
am I going the wrong way about doing this? There is always a smarte
way. Whatcha got for me. (PS You guys/gals are the best help I got.
My IT guy looks at me like im stupid.