Re: update data validation list with new entries??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Dave,
I tried it that way as well. It must be my lack of understanding Macros.
When I use Debras helpful web page, I follow alll the instruction to the
letter and make sample sheets exactly like hers but it still doesn't work. I
know nothing about "macros" or "view codes". I think her tips are based on
the assumption that users are not using XL for the first time. Am I suppose
to copy and paste the sample codes into my workbook?? When I did that I get a
"run time error" message on my sheet with the DV and the code highlights:
Set rng = ws.Range(Cells(1, Target.Column) & "List")
"List" refers to "Target" on this line in the code:
Private Sub Worksheet_Change(ByVal Target As Range)

So it appears I need to make the code "specific" to what I am trying to do,
I just don't know how.

"Dave Peterson" wrote:

> What happens if you start your list in A1 instead of A2?
> And change this to start at A1:
> =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A),1)
> to
> =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
>
> (Remember nothing else in that column and no gaps!)
>
>
> cjtj4700 wrote:
> >
> > Thx Gord. I must be challenged. I opened a blank sheet and followed the
> > instruction link you included for dynamic ranges but no luck. Really green! I
> > made a list of A to G (A2:A7), named it "Letters", selected a cell and
> > entered the DV list "Letters". Went to Insert/Name/Define. Selected Letters
> > from my list of names and entered this into refers to
> > =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A),1)
> > Go back to DV cell, list works, typed the letter H, doesn't get added to
> > source list.
> > Ugh!
> >
> > "Gord Dibben" wrote:
> >
> > > See Debra Dalgleish's site for info on Dynamic Ranges
> > >
> > > http://www.contextures.on.ca/xlNames01.html#Dynamic
> > >
> > > And how to use them in DV lists.
> > >
> > > Also check out her Home Excel page to see much more on Data Validation.
> > >
> > > http://www.contextures.on.ca/tiptech.html
> > >
> > >
> > > Gord Dibben Excel MVP
> > >
> > > On Fri, 9 Dec 2005 15:02:02 -0800, "cjtj4700"
> > > <cjtj4700@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> > >
> > > >Hi Excel Gurus,
> > > > I am very green @ XL so bear with me. I have created a shipping request
> > > >form and added data validation drop down lists for every category (ship to
> > > >company name, address, city, etc.) This data was imported from our preferred
> > > >carriers online address book. What I am looking for is a way to have the
> > > >source list update each time a user enters a new entry and have it placed
> > > >into the appropriate list alphabetically. These are routinely shipped to
> > > >locations but there are over 100 and growing each day.
> > > > Thus far XL appears to be able to do anything except make me a cup of
> > > >coffee so I just know what I am asking help for is probably "XL 101" to you
> > > >all! Please bear in mind that simply replying with a code will do a fly by on
> > > >me!!
> > > >Thx in advance. CJ
> > >
>
> --
>
> Dave Peterson
>
.

Relevant Pages

  • Re: Is this a tennis list?
    ... Dave, can you do your politicking on some other list or lists, please? ... in most cases the identity of the poster has no bearing on by ... Feel free to use fake locations and fake names but no more than one ...
    (rec.sport.tennis)
  • Re: Is this a tennis list?
    ... Dave, can you do your politicking on some other list or lists, please? ... in most cases the identity of the poster has no bearing on by ... Feel free to use fake locations and fake names but no more than one ...
    (rec.sport.tennis)
  • Re: Royalties for BB?
    ... >> Dave acknowledged it was, while Dave is correct in it not being in the ... Sorry, Bill, no ... >> thoughts about lists and Fair Use. ... >Single words and short phrases are not generally up for copyright. ...
    (alt.internet.search-engines)
  • Re: HELP - cannot list files from network drive
    ... "Dave" wrote in message ... > lpszPath to point to a network directory, then it lists no files. ... These functions are available on every 32-bit version of Windows & even ...
    (microsoft.public.vc.mfc)