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
|