Thread: excel2016: can't create dropdown
View Single Post
 
Old 11-13-2016, 12:32 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Changed name of present sheet Worksheet 1 to Sheet1
Inserted a new sheet and named it Sheet2
In Sheet2!A1 I inserted the following formula:
=INDEX('רשימת עובדים להעלאה'!$A$1:$X$1;COLUMNS('רשימת עובדים להעלאה'!A1:$A$1))
Copied this formula to A1:X1.
Selected Sheet2!A1:X1, took a copy and pasted to the same range as values.
Deleted sheet רשימת עובדים להעלאה.
Selected Sheet2!F2, Data, Data Validation, List and selected Sheet1!A1:A4. (=family_status). OK.

Don't ask me about the very strange behaviour of sheet רשימת עובדים להעלאה. I wonder if it may have been set up by someone reading from right to left??
Reply With Quote