Need to split a worksheet into multiple worksheets

[DarlaLu]

I have a worksheet that I need to split it up into separate worksheets based on the dept name or number which are located in either column T (dept name) or column U (dept #). It's been a while since I have had to write a macro and I am struggling.

Thanks

 

[sheetspread]

Here's 2, the second keeps the formulas:

https://www.mrexcel.com/forum/excel...nto-multiple-worksheets-change-row-value.html