items from dropdown list from separate workbooks

[xcelbild]

hi, I would like to be able to enter items from a workbook into another workbook . if possible to be able to type the first few letters of the item and have all the matching items come up in a dropdown list then be able to select the item and enter it in the workbook so that i can create a list of required items from a larger list in another workbook.
cheers.

 

[Yongle]

Welcome to the forum

Does the original list contain unique items ? ( no duplicates values )
Are there any number-only values in the original list ?
Is a VBA solution acceptable ?

 

[xcelbild]

Welcome to the forum

Does the original list contain unique items ? ( no duplicates values )
Are there any number-only values in the original list ?
Is a VBA solution acceptable ?

thanks for your welcome and your rapid response.
no the list doesn't contain duplicate values it is a list of different items.
there are numbers and words such as 125mm angle grinder
as I am a newbie to spreadsheets am not sure what a VBA is?

 

[Yongle]

as I am a newbie to spreadsheets am not sure what a VBA is?

VBA
Several steps are required to achieve what you want
- macros could be used to automate those steps
- macros are written using VBA
- VBA is programming language
Click on link below and watch video illustrating example VBA method
https://www.youtube.com/watch?v=Gm5m-y49rI0

VBA can be avoided
Click on link below and watch video illustrating example non-VBA method
https://www.youtube.com/watch?v=vkPoViUhkxU

In both videos everything happens in one workbook
Both methods could be tailored to use one workbook as the source and another for your new list

Reply on this thread if you require further help

 

[Yongle]

Perhaps this simplified overview of VBA solution would be helpful so that you can see how method in video in post#4 could be tailored to provide a solution that works for you

- opening Results workbook triggers Source to be opened, list auto-copied from Source and pasted into temporary (hidden) sheet in Results
- Source workbook is auto-closed
- user clicks on next cell in column A in Results workbook
- this triggers event macro to show combobox (possibly in a userform)
- combobox list changes as user types (in manner similar to VBA video in post#4)
- combobox value selection (by user) triggers cell value to be updated
- combobox is auto-cleared and hidden
- the temporary sheet is auto-deleted when Results workbook is closed

 

[xcelbild]

Perhaps this simplified overview of VBA solution would be helpful so that you can see how method in video in post#4 could be tailored to provide a solution that works for you

- opening Results workbook triggers Source to be opened, list auto-copied from Source and pasted into temporary (hidden) sheet in Results
- Source workbook is auto-closed
- user clicks on next cell in column A in Results workbook
- this triggers event macro to show combobox (possibly in a userform)
- combobox list changes as user types (in manner similar to VBA video in post#4)
- combobox value selection (by user) triggers cell value to be updated
- combobox is auto-cleared and hidden
- the temporary sheet is auto-deleted when Results workbook is closed

Hi Yongle, thanks for your reply - it's all too much for me, I think it will be easier and quicker to engage someone to set this up.

 

[Yongle]

If you are prepared to forego making the list sensitive to what is entered in the box ...

... there is a fairly simple way to use a list in one workbook as the dropdown in another workbook. Have a look at the video on this link
https://www.contextures.com/xlDataVal05.html

Notes
1. If you want to have a go...
- the name of the workbook containing the list IN THE VIDEO does NOT contain spaces
- if YOUR workbook name contains spaces then that name must be enclosed in single quotes when the named range is created in the other workbook

Named range MyCustList RefersTo formula then becomes ...
='The Name Of Your File.xlsx'!CustName

2. The named range in the video is static
- it can be made dynamic later
- reply to this thread if you want some help doing that