B
bbcdancer1
Been stressing out, got a corrupted a excel file and have lost a piece
of VBA code.
I have a main excel list which I want to split into various worksheets
in the same excel workbook.
The excel 'main list' looks something like this:
cus_id name surname com_type tel
---------------------------------------------------------------
11 mike mills HM 01213423
2 sue bell WK 1312431
11 mike mills FX 4124144
4 robert kent HM 12412341
5 bill murray OT 6464545
6 kevin costner SA 12314225
6 kevin costner FX 23525555
81 jack ripper ZA 21156
9 .....
(The list goes on, records may vary each month)
1.What I would like is a separate worksheet for each different
com_type.
2.Each separate worksheet should be named after the com-type name. eg.
HM, WK, FX and etc.
Note:the number of com_type from the 'main list' may vary from month
to month.
3.Each record from the main list that matches the com_type name must
be copied to the specified com-type worksheet.
4.The number of records from the 'main list' will vary from month to
month.
5.The 'main list' should remain intact.
6.Would like the vba to go through each record rather than using the
excel filter method.
7.Currently using excel 97.
Any help would be appreciated to the fullest...
of VBA code.
I have a main excel list which I want to split into various worksheets
in the same excel workbook.
The excel 'main list' looks something like this:
cus_id name surname com_type tel
---------------------------------------------------------------
11 mike mills HM 01213423
2 sue bell WK 1312431
11 mike mills FX 4124144
4 robert kent HM 12412341
5 bill murray OT 6464545
6 kevin costner SA 12314225
6 kevin costner FX 23525555
81 jack ripper ZA 21156
9 .....
(The list goes on, records may vary each month)
1.What I would like is a separate worksheet for each different
com_type.
2.Each separate worksheet should be named after the com-type name. eg.
HM, WK, FX and etc.
Note:the number of com_type from the 'main list' may vary from month
to month.
3.Each record from the main list that matches the com_type name must
be copied to the specified com-type worksheet.
4.The number of records from the 'main list' will vary from month to
month.
5.The 'main list' should remain intact.
6.Would like the vba to go through each record rather than using the
excel filter method.
7.Currently using excel 97.
Any help would be appreciated to the fullest...