Separate data onto multiple tabs based on partial cell match

[colinh69]

Hi,

I could really use some help here. I have been working on this for a week now and have only gotten so far as to create a new worksheet for each unique cell in column A but I need to search column A and copy each row based on partial match because I have a few cells with the similar contents and I need these grouped together.

I have copied a sample of the sheet and info on it.

Thanks

Customer County Start Finish Notes
Arthur Data Data Data Data Data
James Data Data Data Data Data
Mark Data Data Data Data Data
amusement, Kilkenny Data Data Data Data Data
Andrew Data Data Data Data Data
George Data Data Data Data Data
Old One Data Data Data Data Data
Pub Data Data Data Data Data
house, Castlerea Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Waterford Data Data Data Data Data
James Data Data Data Data Data
Pub Data Data Data Data Data
Pub Data Data Data Data Data
Pub Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
Pub Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Waterford Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
Conway, John Data Data Data Data Data
O'Kelly, Regina Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
O'Kelly, Regina Data Data Data Data Data
amusement, Arklow Data Data Data Data Data
amusement, Waterford Data Data Data Data Data
amusement, Wexford Data Data Data Data Data
house, Castlerea Data Data Data Data Data
palace, Newcastle West Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, New Ross Data Data Data Data Data
amusement, Wexford Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
house, Castlerea Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
house, Castlerea Data Data Data Data Data
house, Castlerea Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
caravan, Tralee Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
palace, Hospital Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
amusement, Arklow Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
Ross Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
palace, Newcastle West Data Data Data Data Data
caravan, Dingle Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
amusement, Arklow Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
house, Castlerea Data Data Data Data Data
palace, Newcastle West Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
house, Castlerea Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
house, Castlerea Data Data Data Data Data
house, Castlerea Data Data Data Data Data
house, Mountjoy Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
caravan, Tralee Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, New Ross Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
amusement, Arklow Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Dungarvan Data Data Data Data Data
amusement, Enniscorthy Data Data Data Data Data
amusement, New Ross Data Data Data Data Data
amusement, Waterford Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
house, Castlerea Data Data Data Data Data
house, Limerick Data Data Data Data Data
house, Midlands Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
house, Portlaoise Data Data Data Data Data
caravan, Dingle Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
amusement, Arklow Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
amusement, Wexford Data Data Data Data Data
house, Castlerea Data Data Data Data Data
palace, Newcastle West Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Wexford Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
house, Castlerea Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
house, Castlerea Data Data Data Data Data
house, Castlerea Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Waterford Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
caravan, Cork City car Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
caravan, Tralee Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Waterford Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Dungarvan Data Data Data Data Data
amusement, Wicklow Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Arklow Data Data Data Data Data
amusement, Cashel Data Data Data Data Data
amusement, Dungarvan Data Data Data Data Data
amusement, Dungarvan Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
amusement, Waterford Data Data Data Data Data
palace, Newcastle West Data Data Data Data Data
caravan, Dingle Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
house, Castlerea Data Data Data Data Data
palace, Newcastle West Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, New Ross Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
house, Castlerea Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, New Ross Data Data Data Data Data
amusement, Tipperary Data Data Data Data Data
amusement, Wexford Data Data Data Data Data
house, Castlerea Data Data Data Data Data
house, Castlerea Data Data Data Data Data
caravan, Fermoy Data Data Data Data Data
caravan, Killarney Data Data Data Data Data
amusement, Carlow Data Data Data Data Data
amusement, Clonmel Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, Gorey Data Data Data Data Data
amusement, New Ross Data Data Data Data Data
amusement, Waterford Data Data Data Data Data
amusement, Wexford Data Data Data Data Data
caravan, Bandon Data Data Data Data Data

 

[Tinbendr]

You're going to have to give more detail in your expected result.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>