Hi All
Need help, have a database with 2 worksheets 2014,2015 up 40000 rows in a workbook.
In same workbook there is is a query sheet with specific criteria headers of 2014,2015.
Not all headers of 2014 & 2015 are required in the query sheets .
Need an efficient formula or vba to find records that match single or multiple criteria in COLUMN B with the the no of counts of records in query sheet
see annexed as sample
Can anyone help me
thanks
1) I corrected the name of your Query Sheet to remove the hidden space at the end
2) The macro will only import from sheets that are named Database ????, the word "Database" is the key
This is filter code:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hopefully I understood what you wanted.
Try this in C2, copied down...
=IF(B2="","",COUNTIF(INDIRECT("'Database "&M2&"'!$A$2:$A$20"),'Query Sheet '!B2))
If that was not what you wanted, please provide additional sample data, and a few more sample answers
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Ford
Just to be more explicit , when I put data in query sheet column A ITEMNO E.G '0000513, then the formula should look in database 2014 and 2015 and put the respective data in columns F TO M according to their headers as per previous attachments .
when I look for another search in query say 0000537 it will list their respective headers F TO M again according to database 2014 &2015 and also give the no of counts found in database 2014 and 2015.
The list has been shortened for ease and note the database may be unsorted .
Hope it helps
Thank you a lot it works marvelously.
Out of curiosity, which 1 worked for you?Originally Posted by JEAN1972
Thank you a lot it works marvelously.
that of JBEAUCAIRE worked.
Glad to hear. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks