Create Sheets based on unique values in Column

Hi all,

I would like to know if anyone knows how to add sheets based on entries of column D (Failure Reason). In sheet1 is the complete data and for each failure reason a sheet needs to be created for it. All those rows of data need to be copied into the corresponding sheet. I currently do this manually using auto filter. This can be quite time consuming. I was thinking of creating a template with all the sheets created, but the failure reason can change all the time. I've attached an example, sheet1 is how the data arrives and the other sheets I add manually.

Thanks

Turn the macro recorder on, Filter the data, copy the filtered data, repeat until all types covered. Turn macro recorder off.

You now have code that can do it over and over again.

Hi xld

I have thought about doing this, but this would need to be amended everytime it is run, which is why I do this manually. Failure reasons are not fixed in type or number. New failure reasons can be created and changed all the time an, so I'd have to check each time what is new and what has been deleted. If the number and types of failure reasons were fixed, recording a macro would be perfect.

Bump to see if there is any takers or if it is possible to do such a thing.

Thanks

Hi I've tried amending the code you've provided before, but the only way I can seem to get it to work is if I move Column D to Column A and amend this line with the coloured number. Not sure how to change it any other way, would you know how to get it to work for Column D?

Please Login or Register  to view this content.

Thanks