Sheet creation based on Cell Value and copy data to the new sheets

[Niranjanrajrishi]

Hello,

I am trying to create Sheets based on the K columns values (Except Header) and paste the respective values from the Sheet Data.

For Example The K column has the value "Older" and Once Sheet created, all the Rows which fall under "Older should move to the newly created sheet (Sheet name should be K column value).

The Macro file attached herewith. The code used in the file shows error as it creates sheets but it continuous even after the required sheets creation (run time error: 1004).

 

[GraH - Guido]

For starters, you do not refer to the correct sheet at the beginning of the macro. If you'd call the macro from Sheet1, since K2 is empty, you iterate trough empty values and try to create a sheet name ""?
Also your data has 43 repeated header rows. You should clean it up first.
Best to generate a unique list of values from K as use this range a parameter to generate new sheets and filter data to copy.

alternative to macro , make a flat pivot (tabular form, without any sub or grand totals) and run "show report filter pages".

 

[vletm]

Niranjanrajrishi
.. or You could test to press [ Do It ]-button
... there are some data, but ... this would MOVE all of those
( If COPY then 'hide' one row from code )

 

[Hareesh_KLD]

Hi Check the attached sheet

 

[Niranjanrajrishi]

Niranjanrajrishi
.. or You could test to press [ Do It ]-button
... there are some data, but ... this would MOVE all of those
( If COPY then 'hide' one row from code )

For starters, you do not refer to the correct sheet at the beginning of the macro. If you'd call the macro from Sheet1, since K2 is empty, you iterate trough empty values and try to create a sheet name ""?
Also your data has 43 repeated header rows. You should clean it up first.
Best to generate a unique list of values from K as use this range a parameter to generate new sheets and filter data to copy.

alternative to macro , make a flat pivot (tabular form, without any sub or grand totals) and run "show report filter pages".
View attachment 50873

Thank you so much! It works like a charm!

 

[Niranjanrajrishi]

Thank you so much! It works like a charm!