Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Sharing data across worksheets within a workbook based on identifi | Excel Discussion (Misc queries) | |||
sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
Splitting Data in a Cell | Excel Worksheet Functions |