I am creating a worksheet with a drop list & need to have various data appear in select rows passed on the choice taken on the list.

For example, if the second item in the dropdown list is chosen, then row 27 and 29 need to contain specific data. The row numbers will be the same regardless of the choice made, but the data within these rows will be different.

Thanks for your assistance.