Results 1 to 46 of 46

Formatting Data of an Auto Populating Calendar Workbook

Threaded View

  1. #11
    Registered User
    Join Date
    11-02-2021
    Location
    Louisiana, USA
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20256) 64-bit
    Posts
    26

    Re: Formatting Data of an Auto Populating Calendar Workbook

    I think you're missing my point, but it doesn't really matter.

    I'm trying to break down this formula:

    =IFERROR(INDEX(Events_Data!$G:$G,MATCH(C4&"_"&$A6,Events_Data!$F:$F,0)),"")

    (This is from Paul's version.)

    So I can populate with the entries in the array that breaks down the multiple day jobs.
    Last edited by mkopenhagen; 11-03-2021 at 01:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] help auto populating a calendar
    By atrout in forum Excel General
    Replies: 18
    Last Post: 03-13-2019, 04:26 PM
  2. Auto Populating calendar that changes all data with each month.
    By VMurtsell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2017, 12:15 PM
  3. Auto-Populating Calendar
    By emk123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2017, 07:29 AM
  4. Auto Populating Calendar
    By NEWBie32 in forum Excel General
    Replies: 2
    Last Post: 01-19-2016, 06:56 PM
  5. Auto Populating Calendar for Multiple Dates from Column Data
    By TrackingDates in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-18-2014, 03:39 PM
  6. Replies: 2
    Last Post: 04-28-2014, 05:17 AM
  7. Replies: 0
    Last Post: 02-21-2013, 09:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1