Autofilter + Copy Paste blank data = problem

[Quint6778]

Hey All....i am having an issue with one specific circumstance. I am filtering a worksheet & pasting the 2 data types(BLUE & RED) into their own worksheets. A problem occurs when one of the data types(BLUE) is non-existent & i cant seem to fix it (im assuming my A2:J range specification is part of the problem, but i just keep messing more up when troubleshooting). I'm hoping one of you will call me out for any nonsense below and provide a simpler solution...

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.