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.
@OnLinePCLearning
9 жыл бұрын
Zac+Millie+Buddy Thanks Zac Trev
@tisue
7 жыл бұрын
Thanks a lot Mr Trevor, god bless you.
@richardnina79
Жыл бұрын
Hi Trevor! Thank you so much for sharing. But, your website is no longer available. Do you have another one?
@gradymartin4669
9 жыл бұрын
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... pffffft.... 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!
@gerardmcnally
8 жыл бұрын
Freeking brilliant ... Thanks !
@janezklun
9 жыл бұрын
Just great video, theme, as always Thank you
@OnLinePCLearning
9 жыл бұрын
janez novak Thanks Janez Trev
@jrgenkjrgaard1014
8 жыл бұрын
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
@alexvinquart4556
9 жыл бұрын
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...
@ogirnoeld2011
8 жыл бұрын
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.
@OnLinePCLearning
8 жыл бұрын
Hi Ogir, Some regions use a semi colon as a list separator instead of a comma. Try replacing , with ; Trev
@ogirnoeld2011
8 жыл бұрын
Hey man I really appreciate it It worked just fine after I did that.. It was kind a weird because all of the other ones worked fine just that one that couldn't figure it out.. thanks a bunch... you the man... blesses .....
@DilleWestr
8 жыл бұрын
Hello, where can I download your excel template? I've tried the link in your description but it doesn't work...
@OnLinePCLearning
8 жыл бұрын
Hi Christoffer, The template is available here. www.onlinepclearning.com/excel-advanced-filter-employee-database/ Best wishes Trev
@claudinedistrito8435
4 жыл бұрын
@@OnLinePCLearning Hi sir trevor. Newbie here. I'm almost done with this userform but it always prompt "type mismatch" when i try to click get contacy. i tried to download the link you've provided but it is not available. can you help with this. badly needed for my project. thanks in advance.
Пікірлер: 20