Auto Cut Rows To Another Sheet When Categorised?

Hi,

I am wondering if someone could help me with adding in a Macro that will take a row and cut and paste it into a relevant sheet, depending on the "Catagory" Column?


For example if "Category" = Manufacture, Paste into "Manu Report"..
"Category" = Clinical, Paste into "Clinical Report"..

Hopefully I have explained this correctly, any help would be greatly appreciated.

Jordan

I had a go at this too.. See attached.

paste_rows.xlsm

Please Login or Register  to view this content.

woops, mistake in my code.. It's not yestno it's boolean yesno.. see attached


paste_rows.xlsm

Hi Dave

Thanks for the file, This works Great!

I just wondered if it is possible to "Cut"/Remove the line from "Sheet1" Data, once the category has been selected?

Thanks Again
Jordan

Hi Dave,

I have just tried the code you sent, but it did not work correctly?

I appreciate your help with this , would it be an issue to set me the code in a new workbook? No worries if this is too much,

Thanks again
Jordan

Thanks for the quick reply, Why does the "Run" button remove once the macro is Run..? Could this be kept in the data sheet?


Jordan