Copy, Paste and Move to different sheet - Code 'Part Working' Help

Hi All,
I have a sheet with a drop down selection box in each row that needs the data to be moved to a different sheet depending upon the selection.
In this example, i want "selection1" from sheet1 to copy into sheet2. I then need "Selection2" to copy into Sheet3 and then "Selection3 to copy to Sheet4 (if that makes sense)???
Now i have this working for one variable but not for the others!
Below code shows "Selection1" as the drop down selection but when i copy this code and change to the other "selections" it doesn't work!

Please Login or Register  to view this content.

Thank You

You need the worksheet_change event, not the selection_change event.

Name the sheets the same as the dropdown selections.

-
2022-07-20_3-04-53.jpg

Please Login or Register  to view this content.

Delete the selection_Change code.

See the worksheet events thread
https://www.excelforum.com/tips-and-...et-events.html