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

splitting data across worksheets
 

you might try typing in "visible cells only"

i think the way you will end up doing it is
1) use autofilter for country England
2) edit goto special visible cells only
3) copy
4) paste into new sheet

is that too heavy?
--
Allllen


"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

splitting data across worksheets
 

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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

--

Dave Peterson

splitting data across worksheets
 

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