I am trying to create a spread sheet that will allow for rows to be copied automatically and put into a separate sheet depending on the drop down selection.
i.e. : If "change order" is selected, I would like that row to be copied to a sheet titled Change order.
I cannot for the life of me make this work. Help?