Rookie q
for the in-cell list part, create a defined name
Insert=Name=Define
Name: List1
Refersto: =Sheet1!$A$1:$A$2
Then in the cell A1 on worksheet2, do Data=Validation, select the list
option and in the box put
=list1
--
Regards,
Tom Ogilvy
"C3" wrote in message
...
How to fill other cell with data from in-cell list?
Example data:
Worksheet 1
A B C D
1 John Street 2 NY
2 Mike Street 3 TX
Worksheet2:
A
1 "In-cell list for data in worksheet1 - list(John, Mike)" For example I
choose John
Then fill cells
A
5 Street
6 2
7 NY
|