VBA split sheets based on multiple condition and preserving format and column width

  • I am brand new to VBA and need some help with the below code. It works well and splits the data based on two filters, but does not preserve column width.
    Could please someone assist and guide me?

    Thank you.

  • Used the code like suggested, it splits keeping the format and columns width, but it is not copying any data. Any ideas what I am doing wrong? Thank you.

Participate now!

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