I have a workbook similar to the one in attachment, there are many sheets where different users updating information in them.
One sheet will retrieve those information from all other sheets. The user will choose what he want to see by sellecting from the dropdown list.
My Problem.I used this formula for dependent validation list
BUT. if the information are not sorted in the source worksheets. it will not work properly.
I need a solution to make that dependent list works without sorting information in source.
Please check the requirement in the video here
[login to view URL]
Array formulas would solve your problem or some VBA code could do the same. I am an Excel VBA expert and familiar with VBA coding. I could help you with this issue with minimum rate. Hope to hear from you soon!
25 freelancers are bidding on average $28 for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
I am experienced in the Data entry, Book Writing and Graphic Designer. I also understand your requirement and my aim is to analyze your requirement in logical way and give you perfect solution
Hi there, are you ok with a macro based solution? I believe your problem reached a complexity that only formulas will not be enough. I am at your disposal to discuss on chat. Thanks for the attention.