HOW TO???

[Robin Hood]

I need to be able to know how to have a cell when selected it would have
a drop down choice of 4 items : "item 1" , "item 2" , "item 3" , Next
Object Number
where if "item 1" is select cell would have text string "item 1"
and if "item 2" is select cell would have text string "item 2"
if "item 3" is select cell would have text string "item 3"
if "next object number" is selected then the cell would contain a four
didgit number which would add 1 to the previous number in the same column
which may be a few rows above.

example

COLUMN "A"
ROW "1" "item 3" ("ITEM 3" WAS SELECTED)
ROW "2" "ITEM 1" ("ITEM 1" WAS SELECTED)
ROW "3" "ITEM 2" ("ITEM 2" WAS SELECTED)
ROW "4" "ITEM 2" ("ITEM 2" WAS SELECTED)
ROW "5" "ITEM 1" ("ITEM 1" WAS SELECTED)
ROW "6" # 1235 ("NEXT PRODUCT NUMBER WAS SELECTED)
ROW "7" "ITEM 3" ("ITEM 3" WAS SELECTED)
ROW "8" "ITEM 3" ("ITEM 3" WAS SELECTED)
ROW "9" # 1236 ("NEXT PRODUCT NUMBER WAS SELECTED)
ROW "10" # 1237 ("NEXT PRODUCT NUMBER WAS SELECTED)
ROW "11" "ITEM 1" ("ITEM 1" WAS SELECTED)
ROW "12" "ITEM 2" ("ITEM 2" WAS SELECTED)
ROW "13" # 1238 ("NEXT PRODUCT NUMBER WAS SELECTED)
ROW "14" "ITEM 1" ("ITEM 1" WAS SELECTED)
ROW "15" # 1239" ("NEXT PRODUCT NUMBER WAS SELECTED)

I know create a data validation list to have a drop down and pick but i
do not know how to add the variable number

TIA if you are able to help (obviously I am a beginner)

Rob

 

[Tom Ogilvy]

Assume the data validation will be in column J.
In another location, create a range of cells like

s1: Item1
s2: Item2
s3: Item3
s4: =IF(ISERROR(LARGE(Sheet1!J:J,1)),1235,LARGE(Sheet1!J:J,1)+1)

assume these are in S1:S4

do insert=>Name=>Define
name: List1
Refers To: =Sheet1!$S$1:$S$4
Click Add.

then in column J

select as many cells as you need and do

Data=>Validation, choose the LIST option and in the resulting textbox put in

=List1

then OK out.

It worked for me.

I don't know how you are going to get the initial number, but if it is
variable, you can replace the hardcoded value 1235 with say a cell reference
such as T1 where you will type in the starting value in T1.

 

[Robin Hood]

in
Thank you very much for your response.... i am attaching the sample
worksheet where i tried to follow the instructions...... i can't figure
out what i am doing wrong .... if you would please see if you can tell
what i have done wrong and post solution

Again I thank you

rob

 

[Robin Hood]

in
Thank you very much for your response.... i am attaching the sample
worksheet where i tried to follow the instructions...... i can't figure
out what i am doing wrong .... if you would please see if you can tell
what i have done wrong and post solution

Again I thank you

rob

 

[Tom Ogilvy]

Where I am reading this, I don't see any attachments.

(e-mail address removed)

if you want me to look at something. Better not to post attachments anyway
- why propogate a file of interest to only one or two all over the internet.

--
Regards,
Tom Ogilvy

in
Thank you very much for your response.... i am attaching the sample
worksheet where i tried to follow the instructions...... i can't figure
out what i am doing wrong .... if you would please see if you can tell
what i have done wrong and post solution

Again I thank you

rob

 

[Robin Hood]

in
I figured out what was wrong.... when i copy paste i got a space in front
of the = ...... sorta screws up the formula .... anyway thanks again
for your help ... once i got it entered correct it worked fine

rob