VBA - Auto Filter and make new sheets based on the filter values- Loop

Dear Experts!

I am in need of a macro that can save my time to split the main database based on an auto filter macro functionality.

I have created a sample macro for your better understanding.

Just to summarize

1. Autofilter and create new worksheets based on the filter value with keeping the same format of the original file.
2. AutoFill Destination Range("A5: A6") to the end of the column.
3. Loop the process until the filter fields get over.
4. Filter Range will vary. (Range("C4:AT12").Select)). So macro should find the end of the range automatically.
----------------------------------------------------------------------------------------

Please Login or Register  to view this content.

----------------------------------------------------------------------------------------

I have done a test and created the following code:

Please Login or Register  to view this content.

Unfortunately, the macro is not copying the range i need to Paste on the newly created sheets. My filter Row Range is from A6 till AT6. The range i need to copy to new sheets starts from C4 till AT and end of the range.

I have attached the sample file for your closer review.

Can any one help me to fix this.


Thanks in advance!