 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008filtering
working on a excel worksheet that my data comes from one program onto a excel spreadsheet. Tried everything and still no go.. trying to filter my data down to one customer and their data only on my spread sheet  Signaturejamesr > working on a excel worksheet that my data comes from one program onto a excel > spreadsheet. Tried everything and still no go.. trying to filter my data down > to one customer and their data only on my spread sheet Not a lot to go on, define "tried everything". Maybe a sample of the data may help. The more detail you give the more likely you'll be to get a usable answer. Have you tried the auto filter feature? gls858 tried that.. boss wants it to filter when info is put on spreadsheet by excel without going in and filtering rest out. What he's wanting is when customer pulls up their own named spreadsheet, all they see is their data only. So that way we have about 15 different spreadsheets for each customer to use. Signaturejamesr > > working on a excel worksheet that my data comes from one program onto a excel > > spreadsheet. Tried everything and still no go.. trying to filter my data down [quoted text clipped - 7 lines] > > gls858 > tried that.. boss wants it to filter when info is put on spreadsheet by excel > without going in and filtering rest out. What he's wanting is when customer > pulls up their own named spreadsheet, all they see is their data only. So > that way we have about 15 different spreadsheets for each customer to use. May be possible with programming but that is beyond my skills. You would have to be MUCH more specific if you expect to get someone to help you program something like this. My first thought would be to give each customer their own workbook. That way no filtering is necessary. Don't know how many customers you have but if each one has 15 worksheet the workbook must have a hell of a lot of tabs! The program your data comes from may be adding extra spaces or hidden characters to the data. Filtering in that case would be next to impossible. Download Chip Pearson's CellView Add-in, install it and see what is in those cells that won't filter. http://www.cpearson.com/excel/CellView.aspx Gord Dibben MS Excel MVP >working on a excel worksheet that my data comes from one program onto a excel >spreadsheet. Tried everything and still no go.. trying to filter my data down >to one customer and their data only on my spread sheet
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.