HI Everyone
I want to create a drop-down list for one Excel worksheet column (user chooses from the list for each cell in the column) using a column of data in another worksheet (primary source). I understand that you use the Data/validation function for this and I have managed to construct what I want this way.
However, I cant find any option allowing me to tack additional columns onto the primary source list for information only. I have done this in the past in Access. You are choosing only from one column in your list of information that you can see in your drop-down box. However, there are other columns beside the list by way of explanation.
Is this possible in Excel?
I would be very grateful for any help.
Georgia
I want to create a drop-down list for one Excel worksheet column (user chooses from the list for each cell in the column) using a column of data in another worksheet (primary source). I understand that you use the Data/validation function for this and I have managed to construct what I want this way.
However, I cant find any option allowing me to tack additional columns onto the primary source list for information only. I have done this in the past in Access. You are choosing only from one column in your list of information that you can see in your drop-down box. However, there are other columns beside the list by way of explanation.
Is this possible in Excel?
I would be very grateful for any help.
Georgia
