filtering

  • Thread starter Thread starter jamesr
  • Start date Start date
J

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
 
jamesr said:
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
Click to expand...

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.
 
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
 
jamesr said:
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.
Click to expand...

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!
 
Back
Top