View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
newshoes newshoes is offline
external usenet poster
 
Posts: 1
Default splitting data across worksheets

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