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.
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
I have done a test and created the following code:
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!
Bookmarks