I have a workbook that is a list of my orders. There are many departments included (Column E). This workbook uses named ranges for data validation (from the "Key" tab).
Is there a way (via VBA) to create a separate workbook for each department and keep the formatting/data validation. There are multiple instances of departments, they are not sorted.
I can do it manually using auto-filter, but with so many departments, it's difficult to do that daily - very time-consuming.
Preferably would like to have each workbook's name to be "Dept" and the number in column E and saved in the same location as this master file.
I've found several solutions but none that seem to fit what I need to do (needing the named ranges, data validation, etc).
Thank you for any help!