Hi everyone,
I have 2 work sheets, the first being the main sheet using drop down lists based on data in the second work sheet. I was wondering how I would be able to populate other cells based on what is chosen in the drop down list. The option chosen in the drop down correspond to some data found in the other worksheet (these are the values I want to auto-populate the other cells)
I have shown in the 1.jpg the values I would like to extract from the second work sheet (2.jpg). Ideally by the end of this I would like to be able to have my first worksheet auto populate based on the drop down list.
I was wondering if the community had any ideas on how to achieve this?
Thanks.
Bookmarks