Moving data from filtered sheet to other sheets

Hello Excel helpfuls!

I have created a macro which takes a large amount of data from one worksheet, filter it by each value in a column one at a time and copy the filtered results over to various sheets.

Sheet 1 is "Input Data" and sheets 2-36 are various sheets based on the data in "Input Data" column B.

My problem arises if the filter returns no values. This creates an issue during the program running because it tries to copy 0 cells over to the other sheet. This always causes the program to crash. Is there any way to fix this?

I have a macro that runs the macro for each sheet and have just been commenting off the ones that are full, but I would love a way for it to be done automatically. Here is an example of one of the macros:

Please Login or Register  to view this content.

Also a way to know when it's more than so many lines so I can split it in to two sheets would be greatly helpful!

I hope I made that clear. I haven't had my coffee yet this morning!

---------- Post added at 12:53 PM ---------- Previous post was at 09:21 AM ----------

I didn't read the ToS for this forum but I'm going to give myself a bump here. Any help would be greatly appreciated!

I didn't read the ToS for this forum but I'm going to give myself a bump here. Any help would be greatly appreciated!

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

Cjdaw,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

You could try something like:

Please Login or Register  to view this content.

Since that last line will count the two header cells.