Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Data List
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: http://www.excelforum.com/member.php...o&userid=32308 View this thread: http://www.excelforum.com/showthread...hreadid=531643 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Data List
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="","","sensitive formula") -- rhovey Wrote: 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? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=531643 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using list box to edit or select data | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Create template that ignors data list rules | New Users to Excel | |||
How to copy data validation utilizing a list to the entire column | Excel Worksheet Functions | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) |