Excel, SQL Server, VBA Automation/VB. Please do ask for assistance for any other technical areas.More bio
Microsoft Excel MVP since 2007.
I consult for a living. I build applications using whatever tools are necessary - Excel, VB, Access, C++, HTML, Perl - whatever the job requires. If I can't do the work quickly and efficiently, there is someone else on my team who can. I specialize in evaluating business environments and devising optimal solutions that enable my customers to realize or exceed their expectations. I also design user interfaces that effectively provide intuitive faces on all types of software and web applications.
Contact me if you need serious help with real problems by sending an email: use the domain zorvek dot com and the address "consulting". These companies have: Gap, Chevron-Texaco, Informatica, salesforce.com, Axioma, Veritas Software, Intero Real Estate, Message One, Cognitive Investments, Dealer One, and America First Marketing.
If you have trouble getting through with the email address above then try the domain gmail dot com and the address "zorvek".
If you want to chat then Skype the handle "zorvek".
If you want to donate to my humble existence then use the domain zorvek dot com and the address "kjones ".
Looking for that elusive October 2001 MSDN disk? I might be able to help.
My name is Kevin Jones. I don't understand why people feel the need to hide their identity. I stand by everything I post on this and any other web site. I take full responsibility for the knowledge and information I publish and I am not afraid of any resulting consequences. My name is Kevin and I sign every post as such.
I earned some points today. Well, I tried...Rory, er, no, Saurabh and Dave got the rest.
Receive something other than points or a T-shirt...then again there is the fan mail...
https://www.experts-exchange.com/questions/21962391/Using-Lookup-and-Reference-functions-with-named-ranges.html?anchorAnswerId=17362613#a17362613 "You guys saved my bacon on this project, THANKS!"
https://www.experts-exchange.com/questions/21966131/Importing-a-txt-file's-comma-separated-e-mail-addresses-into-Excel.html?anchorAnswerId=17384329#a17384329 "YEAH YES INDEED..........I'll never let my subscription to the site lapse again"
https://www.experts-exchange.com/questions/21967539/Count-Distinct-Cells-that-meet-a-criteria-Max-Points.html?anchorAnswerId=17390782#a17390782 "Me one happy bunny now....!"
https://www.experts-exchange.com/questions/21987040/I-need-a-macro-to-run-every-time-I-swtich-to-a-particular-worksheet.html?anchorAnswerId=17507239#a17507239 "I love you!...Not to be gay or anything... Haha"
https://www.experts-exchange.com/questions/21994047/Need-help-with-VBA-code.html?anchorAnswerId=17547985#a17547985 "Kevin, you are God!"
https://www.experts-exchange.com/questions/22014688/VBA-Timer.html?anchorAnswerId=17672545#a17672545 "Absolute Perfection!!!"
https://www.experts-exchange.com/questions/22012642/VBA-Clipboard-Unstable.html?anchorAnswerId=17675067#a17675067 "BRILLIANT!!! It's wonderfully stable and faster, thanks a LOT!"
https://www.experts-exchange.com/questions/22019709/Changing-the-size-of-a-named-shape-on-another-sheet-without-selecting-anything.html?anchorAnswerId=17702035#a17702035 "How the hell did you answer me so fast?!!!"
https://www.experts-exchange.com/questions/22021426/Chart-Wizard-Grayed-Out.html?anchorAnswerId=17711837#a17711837 "WoW Ho. You're the best. Thanks for the quick help!"
https://www.experts-exchange.com/questions/22028172/Excel-Pivot-Table-Hide-Drop-Down-Arrow-button-from-all-pivot-fields.html?anchorAnswerId=17753291#a17753291 "Ohhhhh YEAH!! That's exactly what I was talking about - Thank you so much. You rock!"
https://www.experts-exchange.com/questions/22048616/Nslookup-in-Excel.html?anchorAnswerId=17871731#a17871731 "Holy Crap - I hope you just had that lying around and didn't code it up for me! That is absolutely incredible!"
https://www.experts-exchange.com/questions/22101183/Using-a-Cell-Reference-in-a-SQL-Query.html?anchorAnswerId=18184506#a18184506 "Brilliant. I shall name my next born child "Kevin"."
https://www.experts-exchange.com/questions/22116601/words-seach-and-copy-records-containing-those-words.html?anchorAnswerId=18284118#a18284118 "This is so much better and more info than from MSDN."
https://www.experts-exchange.com/questions/22119398/I-wish-to-find-keywords-across-multiple-columns-in-a-single-row-and-then-list-them-in-a-single-cell-in-comma-separated-values.html?anchorAnswerId=18295779#a18295779 "OH MY GAWD... KEVIN, THANK YOU! You are a Experts-Exchange GENIUS! How much I love you I cannot explain. Bless your beautiful mind. :)"
https://www.experts-exchange.com/questions/22124693/Add-code-to-existing-xls-using-VBA-Error-1004.html?anchorAnswerId=18327643#a18327643 "I am speechless. It is such a pleasure to read your masterful code pieces. You may qualify as VBA Mozart."
https://www.experts-exchange.com/questions/22138895/Deleting-a-hyperlinks-file.html?anchorAnswerId=18410107#a18410107 "Works! Thanks.... you are awesome at this stuff."
https://www.experts-exchange.com/questions/22141527/Copy-and-Insert-Overwrite.html?anchorAnswerId=18424830#a18424830 "You are a god. :-)"
https://www.experts-exchange.com/questions/22396713/Extract-filename-from-a-full-path-in-Excel.html?anchorAnswerId=18558926#a18558926 "Man, you make it look oh so simple."
https://www.experts-exchange.com/questions/22480587/Excel-VB-Error-Message.html?anchorAnswerId=18818193#a18818193 "YOU ARE AWESOME! Thank you, thank you, thank you, thank you!!!"
https://www.experts-exchange.com/questions/22568687/how-do-I-refresh-a-VB-Label.html?anchorAnswerId=19079635#a19079635 "THX! ha ya, you're just too awesome at this program"
https://www.experts-exchange.com/questions/22631575/Cell-shading-depending-on-value-2-cells-below-in-a-row.html?anchorAnswerId=19275910#a19275910 "Peachy. That last one works perfectly. When you have no more use for your brain - mail it to me!!!"
https://www.experts-exchange.com/questions/22674327/Automate-getting-historical-data-from-Finance-Yahoo-website-into-Excel-sheet.html?anchorAnswerId=19424879#a19424879 "Nothing personal, but I love you man!"
https://www.experts-exchange.com/questions/23293282/Deleting-the-entire-row-when-refreshing-external-data.html?anchorAnswerId=21284287#a21284287 "THAT'S IT!!! You rock!! This is SO much easier than my first idea ... thank you!"
https://www.experts-exchange.com/questions/23306053/Count-the-frequency-of-words-in-a-range.html?anchorAnswerId=21316127#a21316127 "That is BRILLIANT!!! Thank you Kevin."
https://www.experts-exchange.com/questions/23356685/How-to-convert-category-names-into-url-alias.html?anchorAnswerId=21448538#a21448538 "I love you, I love you. I love you. Thank you so much. :)"
https://www.experts-exchange.com/questions/23503931/How-to-refresh-a-read-only-excel-workbook-part-2.html?anchorAnswerId=21838908#a21838908 "This is fascinating...kind a metaphysical existence...if Issac Asimov would still be alive...this piece of code it would sparked an idea for a science fiction novel"
https://www.experts-exchange.com/questions/23634779/FAO-zorvek-Macro-you-provided-Need-further-advice.html?anchorAnswerId=22195651#a22195651 "zorvek, once more I am in awe of your mad skills :)"
https://www.experts-exchange.com/questions/23639198/Add-Tab-Name-to-Formula.html?anchorAnswerId=22214583#a22214583 "You are so totally awesome. That works perfectly."
https://www.experts-exchange.com/questions/23692961/Transfer-spreadsheet-data-to-access-overwrite-existing-transfer-range-instead-of-looping.html?anchorAnswerId=22363787#a22363787 "You are a legend. One more question... are you a robot? ... your responses don't have any trace of human error. You must be some sort of AI."
https://www.experts-exchange.com/questions/23815507/Calculating-the-friday-given-a-specific-Week-and-Year-in-Excel.html?anchorAnswerId=22724960#a22724960 "You seem like a ridiculously stellar Excel genius."
https://www.experts-exchange.com/questions/23830842/VB-sort-and-filter-see-attached.html?anchorAnswerId=22761685#a22761685 "you are awesome. i'm going to get "kevin is the greatest!" tatooed around my left nipple. it'll be in skin tone ink, but we'll both know it's there. i'm in awe."
https://www.experts-exchange.com/questions/25001381/Can't-view-sheets-even-after-unhiding-all-sheets-VeryHidden.html?anchorAnswerId=26117997#a26117997 "I always knew you are a living legend...but this was the first time I had the pleasure to raise a question which was solved by you...I don't have words to thank you...YOU ARE GREAT. :)"
https://www.experts-exchange.com/questions/25042066/No-Macros-vba-Offset-Manipulation-for-data-retrieval-2-columns.html?anchorAnswerId=26279480#a26279480 "Dang. I think it would have taken me 3 months to come up with that. Thank you."
https://www.experts-exchange.com/questions/25051820/Hidden-rows-showing-up-in-my-email-attachment.html?anchorAnswerId=26308642#a26308642 "WOAH,it worked! - AWESOME!! thank you soo very much!!!! u the man :)
https://www.experts-exchange.com/questions/25343275/two-way-lookup-issue.html?anchorAnswerId=27621362#a27621362 "SAAWWEEEETTTT!!!!!!!!! YOU GUYS ARE F'ING AWESOOOMMEE!!!"
https://www.experts-exchange.com/questions/26942254/Separate-name-and-suburb-to-allow-list-sort-by-suburb.html?anchorAnswerId=35348826#a35348826 "Immediate and brilliant. Thank you!"
https://www.experts-exchange.com/questions/26945247/Excel-VBA-ActiveX-Change-Event-Error.html?anchorAnswerId=35359158#a35359158 "Kevin, you're a rock star. Spent so much time on this. You got it immediately and helped me see a different angle. Thanks so much."
https://www.experts-exchange.com/questions/26946372/Formula-advice-on-how-to-return-value-based-on-specific-text-within-string.html?anchorAnswerId=35363255#a35363255 "Just tried it then and it's fantastic, thanks for your help and time Kevin!! I appreciate it!"
https://www.experts-exchange.com/questions/27558641/Not-Copy-Macros.html?anchorAnswerId=37513263#a37513263 "Zorvek went way above and beyond to get this resolved wish I could have given 4x the points."
https://www.experts-exchange.com/questions/21153244/A-new-one-joins-the-Excel-HOF-Congratulations-to-zorvek.html - Breaking into the Excel top 10 list on 1 Oct 2004
https://www.experts-exchange.com/questions/21167757/Congratulations-to-our-new-Guru-zorvek.html - Reaching Guru certification level in Excel on 13 Oct 2004
https://www.experts-exchange.com/questions/21214389/Congratulations-zorvek.html - Reaching Wizard certification level in Excel on 20 Nov 2004
https://www.experts-exchange.com/questions/21249169/Congratulations-to-our-new-Sage-Zorvek.html - Reaching Sage certification level in Excel on 20 Dec 2004
https://www.experts-exchange.com/questions/21453373/Congratulations-to-our-new-Genius-zorvek.html - Reaching Genius certification level in Excel on 9 Jun 2005
https://www.experts-exchange.com/questions/21644455/Welcome-to-the-2-million-club-zorvek-is-now-a-double-Genius.html - Reaching second Genius certification level on 27 Nov 2005
https://www.experts-exchange.com/questions/21856343/Congratulations-to-our-triple-Genius-zorvek.html - Reaching third Genius certification level on 18 May 2006
https://www.experts-exchange.com/questions/22036003/Congratulations-to-our-new-Quadruple-Genius-zorvek.html - Reaching fourth Genius certification level on 24 Oct 2006
https://www.experts-exchange.com/questions/22158757/Congratulations-to-our-five-time-Genius-zorvek.html - Reaching fifth Genius certification level on 11 Feb 2007
https://www.experts-exchange.com/questions/23829155/Congrats-Kevin-for-first-Savant-in-Excel-Zone.html - Reaching Savant certification level on 20 Oct 2008
Wackiest question in which I participated: https://www.experts-exchange.com/questions/21407772/liquor-management-sortware.html
Funniest posts, period. Also known as the Daryl Fong incident. Note in each that Wakeup becomes increasingly agitated:
There are more along with some CS questions as the folks in charge tried to figure out who Fong was. In the end about 10 accounts were suspended and the Fong legend was born.
Most fun question (the workbook, the hexagonal cell, and the post conference gang of geeks): https://www.experts-exchange.com/questions/23654024/What-software-do-I-need-to-create-a-spreadsheet-with-hexagonal-or-octagonal-cells.html
https://www.experts-exchange.com was originally www.expertsexchange.com.
Question: How many Experts does it take to write an Excel formula?
Answer: Post a question asking for one in the Excel zone - the easier the better, ignore it for a few hours or a week, and then tabulate the fun.
Question: How do you know when you have been using Excel for too long?
Answer: When someone says to you "FU2" and you think they are referring to a cell.
[Courtesy of Mr. Tim Zych, author of Workbook Compare http://www.higherdata.com]
Good luck Mr. Zych - wherever you are.
https://www.experts-exchange.com/questions/23509410/I-need-to-calculate-the-average-for-a-row-where-the-entries-are-text-a-b-c-or-d.html?anchorAnswerId=21851394#a21851394: "It's not the size of the formula, it's how you enter it that counts.", rorya
Who nominated me Douche of the Year?
Where did "zorvek" come from?
Was this your lucky day? Make me happy and buy me lunch. See above for how to send those happy bucks.