Get Digital Help
  • Home
  • Templates
  • Products
  • Categories
    • Advanced Filter
    • Automate
    • Combine/Merge
    • Compare
    • Conditional Formatting
    • Count Values
    • Dates
    • Drop Down Lists
    • Duplicate Values
    • Finance
    • Misc
    • Pivot Table
    • Random
    • Records
    • Search/Lookup
    • Sort Values
    • Templates
    • Unique Distinct Values
    • Unique Values
    • Unique Values
    • User Defined Functions
    • VBA
    • VLookup
    • Unique/Duplicates
    • Sort values
    • Count values
    • Search/Lookup
    • Microsoft Excel
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read

      Most Popular Blog Posts

      How to extract a unique distinct list from a column

      How to return multiple values using vlookup

      Create a date range using excel formula

      Count unique distinct values in a column

      Sorting text cells using array formula

      How to create a dynamic chart

      Match two criteria and return multiple rows

      Merge two columns into one list

      Lookup with multiple criteria and display multiple search results using excel formula

      Find latest date in a list

    • Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.
    • Random Data Generator 250x250 ad 3
    • Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.


    You are here: Home >> Excel >> Automate

    Archive for the ‘Automate’ Category

    Add or remove a value in a drop down list
    Open excel files in a folder (vba)
    Copy table design settings
    Auto populate a sheet
    Toggle a macro on/off using a button
    Calculate dates in each step in a project based on a finish date
    Automate data entry (vba)
    Apply data validation lists dynamically (vba)
    Excel charts: Multiple series and named ranges
    Change chart data range using a drop down list (vba)
    Separate numbers from a text string
    Dynamic Gantt charts in excel 2007
    Excel vba: Filter a table using the selection change event
    Excel udf: Sumif across multiple sheets
    Auto refresh a pivot table in excel
    Excel charts: Use dynamic ranges to add new values to both chart and drop down list
    Calculate average of last 10 data (possible blanks) in excel
    Create a dynamic named range in excel
    Bill reminder in excel
    Tracking a stock portfolio #2 in excel
    Tracking a stock portfolio in excel (auto update)
    Automate excel: Update list with new values
    Filter common values between two ranges using array formula in excel
    Filter values existing in range 1 but not in range 2 using array formula in excel
    How to remove common values between two columns
    How to find common values from two lists
    Excel 2007: How to create a dynamic chart
    « Previous Page — « previous entries
    next entries » — Next Page »

    • Related blog posts

      • Excel vba: Select value based on time and date
      • Calculate your stock portfolio performance with Net Asset Value based on units in excel
      • Convert date ranges into dates in excel
      • How to calculate missing months in a given date range in excel
      • Excel: Calculate last date of a specific month
      Add RSS subscribe

    • Blog updates by email:

    • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
      Don´t forget to add my RSS feed and subscribe to new blog articles by email.

    • Recent Comments

      • khuram khalil on How to return multiple values using vlookup in excel
      • Nick on How to extract a unique distinct list from a column in excel
      • Ryan on Sorting text cells using array formula in excel
      • Paul on How to return multiple values using vlookup in excel
      • Oscar on How to return multiple values using vlookup in excel
      • Oscar on Match two criteria and return multiple rows in excel
      • Oscar on Learn how to return values depending on udf deployment (vba)
      • Monirul Islam on How to return multiple values using vlookup in excel
      • Rick Rothstein (MVP - Excel) on Learn how to return values depending on udf deployment (vba)
      • Paul on How to return multiple values using vlookup in excel

    • Recent Posts

      • Create comments in cells whose value is larger than the column width
      • Lookup multiple values in different columns and return a single value
      • Learn how to return values depending on udf deployment (vba)
      • Select a cell in a table and the chart updates automatically (vba)
      • Excel template: Getting Things Done (vba)
      • Disable autofit column widths for all pivot tables in a sheet
      • Vba macro: Normalize data
      • Date ranges: Weeks within a month
      • Add values to different sheets (vba)
      • Add values to a table (vba)