Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Monkey Tools Add-in
    • Books & Other Products
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Affiliate Sales Program
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Resources
    • Online Training
    • Recommended Books
    • Add-ins & Tools
    • Excel Blogs
    • Useful Links
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Home

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Monkey Tools
  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (9)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (12)
    Excel - Power Query (3)
    Excel - PowerPivot (7)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (49)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (1)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    Power BI (3)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (10)
    Word - VBA Programming (8)
  • misi01

    There is no available content written by misi01
  • MVP Logo
  • Recent Forum Posts

    rollis13

    VBA Duplicate Value in Column And Perform Calculation

    Try with your revisited code, maybe it's closer to your needs.[CODE]Option Explicit '...

    rollis13 Yesterday, 11:58 PM Go to last post
    Ken Puls

    Datasource: XLS(x) vs CSV?

    Yep, that's the type of of ordering I'm talking about. Personally, I never re-order columns as I always load data to the data model anyway.
    ...

    Ken Puls Yesterday, 10:24 PM Go to last post
    Nick Burns

    Datasource: XLS(x) vs CSV?

    Interesting approach.

    I do have some merges and sorts in the model. For reordering, are you talking about the column order? I try to keep...

    Nick Burns Yesterday, 10:04 PM Go to last post
    Ken Puls

    Datasource: XLS(x) vs CSV?

    In order to get a speed test of a block of code I create a query that performs just the steps I want to analyze, make sure it loads to a worksheet or...

    Ken Puls Yesterday, 06:00 PM Go to last post
    Nick Burns

    Datasource: XLS(x) vs CSV?

    That was what I suspected - thanks for verifying!

    Now I just have to figure out why my report (45c x 3500r) takes so long to parse.
    ...

    Nick Burns Yesterday, 04:26 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 02:23 AM.
Powered by vBulletin® Version 4.2.5
Copyright © 2021 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it