I attached the workbook. Once you select a selection from column J dropdown it will add the row to its destined sheet however if I select the same selection twice it will not continually add rows to the sheets.
Hey guys I currently have an excel sheet where column J has a dropdown arrow with 42 selections.
I have made 42 sheets matching those selections. I need a way to have excel copy and move the rows to their sheet based on the selection. For example everytime I select "AMI" that row i made the...