zorvek (Kevin Jones)
Consultant
  • United States of America
Member Since: 2003/11/05
Industry: Computer & IT
Top Skills:
Tech Certifications:
CERTIFIED EXPERT

Excel, SQL Server, VBA Automation/VB. Please do ask for assistance for any other technical areas.

More bio
Activity
Points this month0
Total points13,340,999
Questions: 181
Solutions: 9198
Articles:
Videos:
Tutorials:
Posts:
Group Discussions: 39
Live: 4
Professional Background
Logic Jock/Slap Boy
Monkey Business, Inc.
More
Education
Hard Knocks
Master
More
Full Biography

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.

Experts-Exchange Milestones:
I earned some points today. Well, I tried...Rory, er, no, Saurabh and Dave got the rest.

Experts-Exchange Goals:
Receive something other than points or a T-shirt...then again there is the fan mail...

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."

Accolades:
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:

https://www.experts-exchange.com/questions/20630877/Computer-will-not-start-in-morning-Fans-come-on-but-no-output-to-monitor-until-unplugged-then-it-starts-normally.html?anchorAnswerId=8610905#a8610905
https://www.experts-exchange.com/questions/20591571/Display-Unreal-Server-Stats-On-My-Web-Page.html?anchorAnswerId=8603299#a8603299
https://www.experts-exchange.com/questions/20629800/Dead-CDRW-Drive.html?anchorAnswerId=8613054#a8613054
https://www.experts-exchange.com/questions/20630014/Socket-Error-10049.html?anchorAnswerId=8610509#a8610509

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

Trivia:
https://www.experts-exchange.com was originally www.expertsexchange.com.

Riddles:

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.

Quotes:
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

Puzzlers:
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.

More
Languages
English
Native or Bilingual Proficiency

Level Progress

Current: Level 81
zorvek (Kevin Jones) needs 107,001 points to level up.
LVL 82
  • Overall
    81
  • Microsoft Excel
    80
  • Visual Basic Classic
    22
  • Microsoft Office
    20
  • VB Script
    16
  • Microsoft Applications
    11
  • Spreadsheets
    11
  • Microsoft Access
    10
  • Programming
    7
  • Visual Basic.NET
    6
  • Microsoft Development
    6
  • Microsoft Word
    6
  • Windows XP
    5
  • Microsoft Legacy OS
    5
  • Microsoft Server OS
    5
  • .NET Programming
    5
  • Outlook
    4
  • VBA
    4
  • Databases
    4
  • Microsoft SQL Server
    4
  • Programming Languages-Other
    4
  • Software
    4
  • Office Productivity
    3
  • Microsoft SQL Server 2005
    3
  • Windows OS
    3
  • Fonts Typography
    3
  • Math / Science
    3
  • C#
    3
  • Adobe Acrobat
    3
  • SQL
    2
  • Microsoft SharePoint
    2
  • Office Suites-Other
    2
  • Web Languages and Standards
    2
  • Scripting Languages
    2
  • Microsoft SQL Server 2008
    2
  • Windows 7
    2
  • MySQL Server
    2
  • Web Development
    2
  • COBOL
    2
  • Algorithms
    2
  • Web Browsers
    2
  • ASP
    2
  • Web Components
    2
  • Programming Theory
    2
  • System Utilities
    2
  • ASP.NET
    1
  • Internet Explorer (IE)
    1
  • Oracle Database
    1
  • Delphi
    1
  • Internet Marketing
    1
  • Crystal Reports
    1
  • Microsoft PowerPoint
    1
  • Productivity Apps
    1
  • Perl
    1
  • HTML
    1
  • Windows Server 2003
    1
  • Microsoft
    1
  • Windows Batch
    1
  • Regular Expressions
    1
  • Windows Vista
    1
  • Installation
    1
  • Web Development Software
    1
  • CAD/Architecture Software
    1
  • Web Applications
    1
  • Peripherals
    1
  • Images and Photos
    1
  • Security
    1
  • Encryption
    1
  • Miscellaneous
    1
  • Storage
    1
  • PHP
    1
  • Pascal
    1
  • C++
    1
  • Server Software
    1
  • JavaScript
    1
  • Visual C++.NET
    1
  • Microsoft Dynamics
    1
  • Anti-Virus Apps
    1
  • C
    1
  • DB Dev Tools
    1
  • Components
    1
  • Windows Networking
    1
  • XML
    1
  • Printers and Scanners
    1
  • Business Management
    1
  • Email Software
    1
  • Firefox
    1
  • Operating Systems
    1
  • Shell Scripting
    1
  • Windows 2000
    1
  • Project Management
    1
  • Exchange
    1
  • Java
    1
  • Storage Software
    1
  • Windows Live Mail
    1
  • Web Servers
    1
  • BlackBerry Programming
    1
  • Citrix
    1
  • Contact Management
    1
  • DB Reporting Tools
    1
  • Document Imaging
    1
  • File Sharing Software
    1
  • Google Chrome OS
    1
  • Google Workspace
    1
  • HTTP Protocol
    1
  • Laptops Notebooks
    1
  • LibreOffice
    1
  • Networking
    1
  • Networking Hardware-Other
    1
  • Project Management Software
    1
  • Smartphones
    1
  • Storage Hardware
    1
  • VPN
    1
  • Windows Server 2008
    1