Filter Records using Advanced Filter and VBA

[cycleninja]

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.


My raw data sheet has a number of blank cells (mostly on the non dropdown data) as I'm still populating it.


Your assistance would be greatly appreciated.


Regards


DB

 

[sdsurzh]

Hi,


Can you please upload the sample file.


Thanks,

Suresh Kumar S

 

[cycleninja]

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

 

[sdsurzh]

Hi,


VBA code password is required to view or modify the code or remove the password and upoload.


Thanks,

Suresh Kumar S

 

[cycleninja]

HI,


Sorry for that.


01977786276


Regards

 

[sdsurzh]

Hi,


I have created a dummy workbook as per your request if you are fine with this please modify the code for your workbook otherwise igonre any one of our excel hero will help you.


http://www.2shared.com/file/-bGZ5j0D/2_online.html


Thanks,

Suresh Kumar S

 

[cycleninja]

Hi Suresh,


The 2 Shared link is not downloading, the only downloadable files are for other sharing software.


Any ideas.


Regards


DB

 

[sdsurzh]

Sorry about that,


https://www.dropbox.com/s/ptgu5in1qxo4fam/2.xlsm


Try this.

 

[gazitaliano]