Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm having a terrible time getting something to work. I want two lists that
will automatically update when a new item is added that is not in the list. I have a work book, representing a year. In the workbook are several sheets, representing autos. In the workbook I have created one sheet that has two lists in it, one for initials (Initial) and one for recording damages(Descrepency). I have named the lists and set the target clumns in the auto sheets to validate to the lists. I read Debra Dalgleish's contextures on dynamic ranges but when I follow the guidance there and insert the if= in defined name, the list names disappear and the worksheets return an error that no list name can be found. I have done everything my limited knowledge allows but have gotten nowhere with this. I got some code from a fine gentleman for lists but it also has failed to allow me to auto update, always returning some error. I love this bulletin, but so far none of the recommended solutions out there are working, I feel I am missing some simple step here. Help?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotals in a list | Excel Discussion (Misc queries) | |||
Auto filtering vs Date List Create List | Excel Worksheet Functions | |||
Auto Fill Cells, When Choosing From Drop-Down List... | Excel Worksheet Functions | |||
Auto Fill using a list of students | Excel Discussion (Misc queries) | |||
Auto scroll down data validation list | Excel Discussion (Misc queries) |