Perhaps you'd like to try a formulas approach which closely fits what you
seem to be after? If so, think you could adapt quite easily the set-up
described in this recent post: http://tinyurl.com/5ejr2

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Steved" wrote in message
...
Hello from Steved
Panmure 10903 27 54.04 200511
Panmure 10915 27 45.80 200511
Panmure 10913 24 43.80 200511
Panmure 10886 23 47.60 200511
Panmure 10922 21 41.47 200511
Panmure 10884 20 38.90 200511

The above is in sheet called Data

I've named 8 sheets with City names

The above is "Panmure" City what formula would I use please
to copy from Data Sheet to the Panmure Sheet.

Thankyou.