Without a filter and copy/paste you need to send the data to the new worksheet.

OR "pull" the data using linked formulas if there is any structure or pattern to
the positioning of the data on source sheet.

It seems to me you need a macro to select the England items and have them show
up on the new worksheet.

See Ron de Bruin's site for some methods of adding selected data to a worksheet.

http://www.rondebruin.nl/tips.htm

Look in the links for "copy/paste/merge examples"


Gord Dibben MS Excel MVP

On Mon, 13 Nov 2006 08:22:02 -0800, newshoes
wrote:

hi!

I am trying to find the right 'key words' to use help - maybe someone can
help me... or suggest where to look.

I have a list of names address etc on on worksheet. I want a new worksheet
for those people, say, in England. instead of a filter I want to make a new
worksheet with only those people in it - but without having to copy and
paste, as this data will be updated regularly. Is there a way to do this?
Anyone know what key word to type into help?!?

thanks