problem with formula
 

i have pulled a spread sheet from sql. all works fine. but now i need to
move parts of the sheet defined by place name. here is a exsample of the
sheet


cromer 1bgfho 7 45
sheringham 1bgfho 7 45


i need to be able for exsample to move sheringham to a separate sheet.
this sheet will be updated weekly via macro's is this possible??


--
Sy.
------------------------------------------------------------------------
Sy.'s Profile: http://www.excelforum.com/member.php...o&userid=30737
View this thread: http://www.excelforum.com/showthread...hreadid=504020