Look at this example and see if it is something you can work with.
On the Sheet1 tab, use the dropdown box in column I to select one of the choices.
Of the three choices, each choice has its own sheet.
When you select one of the three choice the row will be copied to the sheet that matches the choice.
|