Quick Question

T

TWrangham

I have a workbook that is basically made up of 2 worksheets, a importing
data sheet and a chart. Everything works great, timely refreshes and its
rather simple. The problem I have is this: The chart is basically a
seating chart and does not change at all(static). The 2nd worksheet
continuosly updates the chart and will sometimes add new
values(dynamic). Well, my formulas that I have for each cell points to
the dynamic sheet and the values will change on occasion,
unpredictablely. How can I write the formulas pointing to certain
values in the data sheet(dynamic) and lock the cells. Then any new data
populated in the data sheet will just go under the locked data which
will not affect my cell references for the chart. If this is really
unclear I can try again. Thank in advance!!!
 
O

OJ

Hmmm...not very clear. Are you using dynamic named ranges? something
like this?

Series1 = Offset($A$1,0,0,counta($A:$A),1)

I think you need to expand on 'lock the cells'. Do you mean a static
range which never changes?

I'm sure we can help but try to rewrite this bit...

How can I write the formulas pointing to certain
values <--do yu mean staic cells or a given value that might appear
anywhere?

in the data sheet(dynamic) and lock the cells <-what do you mean?
.. Then any new data
populated in the data sheet will just go under the locked data which
will not affect my cell references for the chart.

O
 
Top