Hello Experts.
I have attached a spreadsheet explaining what I am looking for.
To summarize, I have different worksheets which consists on company information and their rate based on weights.
I am looking to build a report page, in which I need two drop downs.The first drop down to choose the company and the second will automatically populate based on the first drop down and get the corresponding data and everytime I choose the value in dropdown, it should change automatically. Your expertise in this regard would be greatly appreciated.