| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort data by name in first column and copy to individual worksheets by name
Does anyone have code handy to sort data into various categories by the
type of data specified in column 1 and then copy the respective data into predefined worksheets with the same category names? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sort data by name in first column and copy to individual worksheetsby name
You might find what you want at Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html Look for: 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 srfrost wrote: Does anyone have code handy to sort data into various categories by the type of data specified in column 1 and then copy the respective data into predefined worksheets with the same category names? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sort data by name in first column and copy to individual worksheets
I'm impressed; exactly what I was looking for. Thanks, Steve
------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sort data by name in first column and copy to individual worksheets
You're welcome.
Debra did nice work. srfrost wrote: I'm impressed; exactly what I was looking for. Thanks, Steve ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Put data into individual worksheets | New Users to Excel | |||
| Sort column ascending on many worksheets | Excel Discussion (Misc queries) | |||
| After I sort a column can I add the date to separate worksheets? | Excel Discussion (Misc queries) | |||
| Automatically copy data from large worksheet into individual workb | Excel Worksheet Functions | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Hybrid Mode
