Excel Advanced Filter – Employee Database

preview_player
Показать описание
Excel Advanced Filter – Employee Database Project. This is an advanced filter, Excel VBA tutorial. In this tutorial we are going to show you how to run an advanced filter that will search all of the columns in your flat file database. The option will be dead a search by individual columns or by every column.
We will be doing this from a multipage user form that will also have the functionality to edit delete and add new data.
Рекомендации по теме
Комментарии
Автор

Hi Trevor! Thank you so much for sharing. But, your website is no longer available. Do you have another one?

richardnina
Автор

Damn you are clever. Now I have something else to practice on in the evenings. I can use this one for my wife's business as they migrate from Lotus Approach.

zacandmillie
Автор

Thanks a lot Mr Trevor, god bless you.

tisue
Автор

Trevor.  I have worked through several of your projects and successfully combined components of them together into one workbook.  Love your instructive videos and all the templates and formulas you have provided for edification... I have learned loads from you and have recommended you to many.  

Now, when I go to add my final component to my project... the Advanced Filter with Multiple Criteria.... can you guess what happens?  My advance filter will only return the header row of my list range... Microsoft can't figure it out... I can't figure it out...

I've even downloaded your template with the working advanced filter macro in it that works (when I run your macro that pulls the data from your data worksheet)... the first time I change the cell values to go to my data worksheet, using your macro... again, just the headers....

Now, I see this new project ... and... basically its doing just what I was creating my project to do.... 

Trevor, if you have any feedback on my comments that you think might help...I would greatly appreciate them...

 I know I'm creating the macro correctly, and identifying all the ranges and criteria and operators correctly... and from the right sheets.

VBA editor is showing no errors, and the macro executes... but, only header rows get copied to the extract range....

PS... Hope we won't have to wait long to get going on this new Project!  It's exactly what I have been trying to do on my own...

Trevor, you are the best!

gradymartin
Автор

Just great video, theme, as always
Thank you

janezklun
Автор

Hi Trevor
I would like to have a field with the date and it works until I press the edit so do not come with the next time I run advanced filter.
can you help

best regards
Jørgen

jrgenkjrgaard
Автор

good morning, I desperately need your help... I'm in love with excel and give my self always some new challenges and I'm really stuck!
I've watched almost all your video and try many of them and I dream to get your knowledge about excel... althought I need your help. how can I send you an excel file to help understanding my crazy project because it's so hard to explain or I make a video to explain you my issue what do you prefer? I really need a guidance...

alexvinquart
Автор

Hello, where can I download your excel template? I've tried the link in your description but it doesn't work...

DilleWestr
Автор

I am on the proyect of employee database but I can't get the name range code to work. It says that I am supposed to insert (') like I see you got on yours. Can you help me. I'm using 2013 thanks in advance.

ogirnoeld
Автор

Hello sir Trevor.
may I get your helo

malikazeem