splitting worksheet
1 Topic
VBA - Splitting worksheet by Dept
Hi This is a complicated task that requires a VBA expert. I have attached a file for you to review. What I would like is a VBA code to be able to take the data and split it into separate worksheet per dept. So I want to filter out one dept at a time on one worksheet. Importantly I want the subtotal at the bottom to remain. So the subtotal would show the filtered total per dept. Also is it possible to rename the new worksheets with the Dept name as well? Please let me know if you can assist with this as it will save me so much time. Thank you in advance. ZiaSolved4.4KViews0likes12Comments