filtering

[jamesr]

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

 

[gls858]

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

 

[jamesr]

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.

 

[Gord Dibben]

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

 

[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!