Forum Discussion
Solved
Auto populate a cell with a table (column) on another sheet.
I have an application where I want to auto populate a cell with a drop down from a (column) table when a certain value is chosen in a third cell. This is so the User can only make a selection from th...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Here you are, sir. So you are aware, SHEET2 is actually the sheet labeled DO NOT DELETE. HansVogelaar
See the attached version. I created several defined names to make it work - see Formulas > Name Manager.
Note: there doesn't appear to be a range for FBS, so you won't see a drop down list in C19 if you select FBS in C8.
- Looks great, thank you! Will you send me the formula you created, please? It isn't showing up in the cell. It is E19 that has to have the drop-down in it. Thanks again, you've helped me with a massive headache! :-[]
There is no formula in C19.
Select that cell and then click Data Validation on the Data tab of the ribbon.
You'll see that the Source of the data validation list is a formula.