A Self Populating List

[MGumbrell]

I have named a range say "range1" and refers to:
=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1,1) which of course allows the range to vary.

On sheet2 in the range Column C there is a drop down list in each cell that refers to:
=range1

What I would like:
Should the user not find from the list range1 a suitable entry that they can type an entry that they would like to use and this entry is then automatically populated into range1 allowing that entry to be included within the dropdown list the next time it is used.

Regards, Matt

 

[HaHoBe]

Hi, Matt,

as long as the suitable place for adding is directly under the last entry in Sheet1 everything will be fine. Else you would need some VBA and a UserForm...

Ciao,
Holger

 

[MGumbrell]

Holger

I would like to try and avoid a UserForm and VBA, but if I enter text in the cell with a dropdown list is sys that it is an invalid entry so, is there a way without VBA to enter text into the cell that will copy the entry at the bottom of the range where the list originated from?

Hope that explaination was clear enough?

Regards, Matt

 

[HaHoBe]

Hi, Matt,

sorry I only know the way by VBA (I´m sort of limited in that )

Ciao,
Holger