Thread: Filtering Issue
01-03-14, 23:34 #1Registered User
- Join Date
- Jan 2014
Unanswered: Filtering Issue
I have a spreadsheet with several columns, and about 5000 rows of data. One of the columns is called Work Code, and contain 1 of the 10000 plus codes used for this column. I have another spreadsheet with about 500 specific work codes.
I need to filter my spreadsheet to return only rows that have 1 or the 500 specific work codes on the separate spreadsheet.
I haven' done this in a while. I thought I used to to this by setting a criteria with a combo box...but all this does is create a drop box on each row with the 500 specific codes...
any help is greatly appreciated.
01-04-14, 10:22 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
You keep referring to 'spreadsheets;' is this an Excel app you're talking about or an Access database, which is the purpose of this forum? And if the latter, are the spreadsheets linked or embedded in the database?
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007