Dropdown list and auto populate

[D_Rennie]

Hi i have a sheet would like to have a few dropdowns for product selection

suppliers are listed in another workbook each supplier has their own sheet would like to have cells b7 down populated with these sheet name or unique entry if needed

from there the catogary will list for this company once selected a catory the range cell will populte with entrys and then the item to be selected in the end filling in decription and price based on these selections.


the attachemt has some notes to help make sence hopefully someone can help on this.

[AliGW]

Have a look here: https://trumpexcel.com/dependent-dro...list-in-excel/

[D_Rennie]

thanks look about right, though am i correct asuming there is no way to referance the sheet names. not too bad i can just put a heading i guess.

just tryed that the duplicates are also a issue

thanks again

[D_Rennie]

Still looking for help on this if anyone is keen

[AliGW]

Maybe this tutorial will help: https://www.contextures.com/xlDataVal02.html

Please upload a workbook where you have tried to implement one of the two and we can then help troubleshoot it for you.

[D_Rennie]

did you see the attachment, how will cell B8 referance the sheet names in a data valadation list. then this sheet could change so i guess i would need to inject a data valadation range with vba to referance what sheet is needed

[AliGW]

I asked for a new attachment showing how you have tried to implement one of the two solutions to which I linked. If I have time later I will have a look, but I am busy at the moment. Sorry.

[AliGW]

I have had a look at your original attachment and cannot find any attempt at dependent drop-down lists there. In which cells have you tried to implement them?

[D_Rennie]

Thanks for the help,

about to go out for dinner show. so ill put the workbook together again after that or in the morning.

its cells b7 down and accross to row e.

the stumbling blokc is i can not figure out how to referancy the many suppliers sheets.

and then having more than 1 supplier sheet is confusing me

i think it may have to go vba as thats what i understand better

[AliGW]

It might be a case of just reorganising your data. Why do you need more than one sheet for suppliers? This is not good database organisation.

[DrGnBld]

I have a similar problem to the OP. On my attached file, I am trying to auto-populate the cells in Z8-Z18 (QC Volumetrics Mix 1 (A)) based upon the corresponding selection from drop down list in Q7. I had thought it would be as simple and copying and pasting the code I have already used on QC Gradation Mix 1 (A) and changing it from pulling the data from the GradSpecs sheet to the BatchedList sheet. This didn't work however, and I played around a few times and was able to get the cells to populate depending on the selection, but the data wasn't in the proper cells and it looked funny, like the alignment had skewed itself somehow. SO I'm out of ideas and hopefully I'll be able to get some help here. Thank you in advance for your time.

[AliGW]

Administrative Note:

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread