Splitting table into worksheets with same layout

Hi everyone,

I’m trying to build a general macro that splits a table into different worksheets according to criteria’s in a column.  The steps should be as follow:

  1. Select column with criteria (maybe with MegaBox)
  2. Select data with specific criteria
  3. Copy the data into a new worksheet (named by criteria)
  4. Save the new worksheet with the criteria as name under the same path as the ActiveWorkbook

For some steps I found some useful macros in the forums but no macro keeps the layout of the original worksheet (for example columns which are grouped by or hidden) what seems to be the main part of the macro.

Can anybody help me with that issue?

Many thanks!

Peter

 

Participant Asked on February 28, 2018 in VBA: Macros.
Add Comment
0 Answer(s)
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.