In this video i explained how to segregate the Column's data into multiple worksheets. As part of this procedure below mentioned topics are covered
(i)User Form
(ii)Change Event Of Listbox
(iii)CountIF Function
(iv)Hide and Unhide the worksheets
(v)For Loop
(vi)Specialcells Method of Range Object
Download The Workbook
http://tricks12345.com/VBAConcepts/Sp...