Friday, February 19, 2016

Listing The Filtered Data On Separate WorkBooks

Creating New Books According To The Unique Values That Consists Of Filtering Result

          UserForm opens automatically when the workbook is opened.When pressed the button on the userform, unique values are listed with the filtering method in a new sheet. Named folder according to date is created.

           According to the unique values in the column A , new workbooks are created in folder , the data are copied into this workbooks.The hyperlinks are created for this new workbooks.