Do you want to Create separate sheets on the basis of column.???
Regards,
Mandeep baluja
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
I want to split table from main table with their names available in column
For example.
I have a database in
Thanks Mandeep for reply.
Below is the column in which we required separate Tablefor each LOB.
*LOB Name* Health Personal Accident Engineering Health Personal
Accident Health Miscellaneous - Package Health Health Personal Accident
Health Health Health Personal
Use this code basically it use the Autofilter technique to create sheets
and use of collection class to remove the duplicates.
Sub Macro60()
'Step 1: Declare your Variables
Dim MySheet As Worksheet
Dim MyRange As Range
Dim UList As Collection
Dim UListValue As Variant
Dim
Thanks dude
but I need code to make separate sheet for each LOB as these needs to
assign work to each individual.
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
I want to split table from main table with their names available in column
For example.
Why you're not using the pivot table feature to create this, Create pivot
and use this column in row field to create separate sheets. only 6 are
required, but if you still wish you can use the code for the same.
Health Personal Accident Engineering Miscellaneous - Package Liability
Brother the code which you have given it is for excel.
I am talking about MS Access
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
I want to split table from main table with their names available in column
For example.
I have a database in the
