G
Guest
Hi!
I have an Exel spreadsheet where the charts work dynamicaly. Every time data
is entered into successive cells the chart will fully expand to reflect the
data entered. Next to each cell of data, there are two formulas. One to
calculate the deviation from the nominal dimension, and wheather that
dimension passed or failed. Is there any way to have these formulas work
dynamically so that everytime data is entered into a cell, the formulas will
be entered into the adjacent cells?
Cal
I have an Exel spreadsheet where the charts work dynamicaly. Every time data
is entered into successive cells the chart will fully expand to reflect the
data entered. Next to each cell of data, there are two formulas. One to
calculate the deviation from the nominal dimension, and wheather that
dimension passed or failed. Is there any way to have these formulas work
dynamically so that everytime data is entered into a cell, the formulas will
be entered into the adjacent cells?
Cal