Hi,
Thanks for the quick response.
Dropbox link below:
http://dl.dropbox.com/u/94076756/Chandoo/QEHB%20As%20Built%20Drawing%20Register.xlsm
Thanks in advance.
Regards
DB
Hi,
I've downloaded the sample file from the site and amended the various named data and their cell references to suit my workbook.
When I run the filter macro, the row headings appear in the filter sheet but no data appears.
I've used sample dropdown data from the raw sheet as criteria...
Hi SirJB7,
The fix worked a treat. I've added the Where statement as the data is still in the process of being finalised.
I can now use this technique on a number of similar projects I'm working on.
Thanks very much for your assistance.
Regards
CycleNinja
Hi SirJB7,
Thanks for the mega quick response. I've had a trawl through the tags etc and a few other locations regarding this error but to no avail.
Please see attached link to my amended file. There are no passwords...
I've downloaded the sample Excel-As-Database-demo-v1 workbook and have modified it to meet the layout of the workbook I'm drafting. I've kept the same 3 combo boxes but have renamed throughout with the new cmb names and SQL fields, the Named Range 'dataSet' has been amended also, along with the...