Copy workbook X times based on unique cell values in column

  • Hello -

    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!

    Example of Workbook

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!