Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering data to new spreadsheet
I want to sort my data and filter it into new worksheets based on the
information from one column. Example: Column A is sales person Column B is customer name Columns C:G is customer information (address, etc...) I want to sort the data by sales person into separate worksheets that I can give to the sales person. Hope that makes sense. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering data to new spreadsheet
Mechanically or manually?
For the latter ... Sort by Column A, Column B Data==Filter=Autofilter Filter by Sales person Copy/paste to Sales Person sheet Repeat for all Sales persons "MEAD5432" wrote: I want to sort my data and filter it into new worksheets based on the information from one column. Example: Column A is sales person Column B is customer name Columns C:G is customer information (address, etc...) I want to sort the data by sales person into separate worksheets that I can give to the sales person. Hope that makes sense. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering data to new spreadsheet
One formulas option which auto-copies it the way you want ..
Try this sample construct from my archives: http://www.savefile.com/files/430142 AutoCopy Lines to Resp Sht Non Array.xls (Full details inside, nicely rendered. Easy to adapt ..) Data is continuously entered in a master ("parent") sheet, with lines neatly auto-copied to each individual ("child") sheet based on the values within a key col. In the sample, the key col in the master sheet is the "State" col, which may contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will be auto-copied to the sheet named: NY, and appear neatly bunched at the top. Ditto for lines with "CA", "NV", etc which will be copied into their respective sheets. Propagation of the "child" sheet is as simple as making a copy of the initial one, then renaming it accordingly as the next key col value. Eg we first formulate one child sheet for "NY", dress it up nicely, then just make copies of the "NY" sheet, and rename these as: CA, NV, SD, etc. In your case, the key col would be the sales person (col A), eg: sales person1, sales person2, etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "MEAD5432" wrote: I want to sort my data and filter it into new worksheets based on the information from one column. Example: Column A is sales person Column B is customer name Columns C:G is customer information (address, etc...) I want to sort the data by sales person into separate worksheets that I can give to the sales person. Hope that makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003; spreadsheet with filtering; deleting rows | Excel Worksheet Functions | |||
filtering data | New Users to Excel | |||
Filtering data | New Users to Excel | |||
Data Filtering | Excel Discussion (Misc queries) | |||
MY SPREADSHEET IS NOT FILTERING CORRECTLY | Excel Discussion (Misc queries) |