Hello everyone. I am having trouble using dropdown list to auto populate other cells in my spreadsheet. I have tried using lookup functions and index functions, but do not have enough excel knowledge to get the task done.
I have attached my excel document. Here is what I am trying to do.
On sheet2 I have a lists of percentages that will feed into a financial statement, however depending on what corporate wants will determine how the financial statement is being impacted.
On sheet3 I have color coded where the information will be linked to from sheet2, so that it is easy to follow.
I want to be able to change the dropdown menu selection on sheet2 and have sheet3 automate with whatever I chose (base,management,sponsor,downside 1, downside 2)
So if I choose Basel, then every row that contains base will populate into sheet 3 where the deemed color code shows.
I have thought that after the data was extracted using an excel function then we could hide that information on another sheet and use a simple link to function to copy and paste the data. But I am not sure if that is the easiest and most efficient way to do this.
If anyone could take a look and help out that would help me out. Thanks
Bookmarks