Hello, I am using win7 64 and Excel 07.
I have 2 sheets of data. Sheet2 is a table listing data in rows for a column of 20 different items. Each item has 19 different values associated with it (if that matters).
On sheet 1, I want to create a similar smaller table with 5 drop downs that list all of the items on Sheet2. When item1 is selected, I want the next 19 cells to the right to populate with the data associated with item1 (the same way it appears on sheet 2). This is so that we can look at different combinations of a maximum of 5 items without needless copy/pasting.
So far I have only been able to create a drop down menu that lists the 20 different possible items, but I have not figured out how to get the next 19 cells to auto-populate with the associated data.
Thank you in advance.
I have 2 sheets of data. Sheet2 is a table listing data in rows for a column of 20 different items. Each item has 19 different values associated with it (if that matters).
On sheet 1, I want to create a similar smaller table with 5 drop downs that list all of the items on Sheet2. When item1 is selected, I want the next 19 cells to the right to populate with the data associated with item1 (the same way it appears on sheet 2). This is so that we can look at different combinations of a maximum of 5 items without needless copy/pasting.
So far I have only been able to create a drop down menu that lists the 20 different possible items, but I have not figured out how to get the next 19 cells to auto-populate with the associated data.
Thank you in advance.
Last edited:
