Need a solution for automatically inserting cells and updating formulas

  • Thread starter Thread starter cabybake
  • Start date Start date
C

cabybake

Hi there,

www.dciu.org/cspd/Excel%20Template.xls

I have a worksheet that I'm working on where teachers can track student
data. I have it set up to create an aimline on a chart where the goal
minus the baseline divided by the number of sessions will create the
change per session. (g-b/s = c). I then have an aimline that starts at
the baseline and then adds the change per session for an amount of
sessions. This part works great. Here's the part I need help with-

I'm specifically working on the worksheet within the workbook entitled
Spec Skills Ratio. I need teachers to be able to add data to new rows
and still have the formulas update themselves accordingly as well as
the chart attached to recognize new data. These teachers would find it
difficult to copy and paste formulas so I would like the worksheet to
do this for them. I do not know how to do VBA or macros, but if you
walk me through it, I might be able to figure things out. I hope this
is clear. Thank you in advance,
cabybake
 
You probably need to work with a predetermined area where the teachers can
enter data.
It may help to colour the area that can be used.
Your formulas should then look at these areas and do the calculations
including any empty lines.
It will help if you give the areas names and use these names in the
formulas.
I f you later need to insert new lines the formulas don't have to be changed
as long you insert above the last lines.
Regards
Bill K
 
Back
Top