LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 159
Default auto updating list

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotals in a list Bagheera Excel Discussion (Misc queries) 9 May 20th 06 01:46 PM
Auto filtering vs Date List Create List torajudo Excel Worksheet Functions 2 January 29th 06 10:30 AM
Auto Fill Cells, When Choosing From Drop-Down List... doc1975 Excel Worksheet Functions 1 January 11th 06 02:36 AM
Auto Fill using a list of students Mary L Excel Discussion (Misc queries) 0 February 8th 05 05:31 PM
Auto scroll down data validation list [email protected] Excel Discussion (Misc queries) 4 January 28th 05 06:44 PM


All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"