Steve

If I understand, you can only realistically do this by putting Police in A2,
A3, etc. That is list the service multiple times. That way you can then
sort on service and then station

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Steve" <swr1953(at)yahoo(dot)co(dot)uk wrote in message
...
Hi
Is it possible to group data together so that it stays together when I
sort it alphabetically? I'd like to make a list for example, Police, Fire
and Ambulance stations. In cell a1 would be Police followed in b1, b2, b3,
etc the names of the stations. Then in c1,c2,c3 etc the relevant telephone
numbers. Then in a 4 would be Fire, followed by b4, b5, b6 etc the names
of the fire stations and then their tel numbers in c4, c5, c6 etc.The same
applies to Ambulance. Then I'd like to sort col A and keep col b and col c
together under the proper emergency service
Hope you can understand what I mean
TIA
Steve