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 |
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) |