Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Books
    • 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.

  • 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)
  • p45cal

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

    p45cal

    Excel:data validation drop-down list- Populate the matching hyperlink from another co

    Consider using a small macro. In the attached, make choices in the green shaded area. To view the code, right-click on the sheet's tab and choose View...

    p45cal Today, 02:27 PM Go to last post
    Bob Phillips

    Source Path from a Cell in the Active Worksheet Vs a named cell

    Yes, it is simple to get the value from a named range

    Code:
    let
        name = Excel.CurrentWorkbook(){[Name=RangeName]}[Content],
    ...

    Bob Phillips Today, 01:38 PM Go to last post
    petraidm58

    Source Path from a Cell in the Active Worksheet Vs a named cell

    I am a power query novice so please provide solutions (if there any) at a level I can understand. Here is my problem:
    My workbook will contain...

    petraidm58 Today, 12:01 PM Go to last post
    bgiovanni1!

    Excel:data validation drop-down list- Populate the matching hyperlink from another co

    So, I wish Excel or Google Sheets had the option of keeping links intact when you did a drop down list in data validation, but it doesn't. I decided the...

    bgiovanni1! Yesterday, 08:54 PM Go to last post
    bobjglover@gmail.com

    Importing Data From MS Word to MS Excel

    Thanks for the assist! I was thinking something similar but you got to it b 4 me ...

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