software

I have created a Data List which includes in one of the cells a
sensitive formula. Since Excel does not allow protection of cells in a
List, I wanted to remove those formulas to a seprate (hidden)
worksheet, which would populate as users entered values in the list on
the original worksheet. However, the list I created on the hidden
worksheet will not expand as the list expands on the original
worksheet. Any idea why?--
rhovey
------------------------------------------------------------------------
rhovey's Profile: www.excelforum.com/member.php...oamp;userid=32308
View this thread: www.excelforum.com/showthread...hreadid=531643
First guess would be that your formula was copied down far enough to
cover your existing volume of data, and did not cover all rows.

You would need to enable your sensitive formula to expand with your
data, or fill the whole column of the hidden sheet with something like=IF(OriginalSheet!A1=quot;quot;,quot;quot;,quot;sensitive formulaquot;)

--

rhovey Wrote:
gt; I have created a Data List which includes in one of the cells a
gt; sensitive formula. Since Excel does not allow protection of cells in a
gt; List, I wanted to remove those formulas to a seprate (hidden)
gt; worksheet, which would populate as users entered values in the list on
gt; the original worksheet. However, the list I created on the hidden
gt; worksheet will not expand as the list expands on the original
gt; worksheet. Any idea why?--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=531643