+ Reply to Thread
Results 1 to 3 of 3

IFERROR autopopulate code isn't bringing the right text from list tab to calendar tab

Hybrid View

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    2

    IFERROR autopopulate code isn't bringing the right text from list tab to calendar tab

    Hello! I've lurked in the forum for a while but this is my first post, please let me know if I'm doing something wrong

    In these forums I found a great Event Calendar spreadsheet that pulls data inputted into a list in tab #1 over to a calendar on tab #2. I was fiddling with the formatting and adding extra columns and such and when I checked the calendar I realized that I must have broken the code to bring over the "Calendar Entry" column items from tab #1 over to the calendar in tab #2. I think it's pulling over column E instead of column G... but when I checked the formulas in the calendar I couldn't figure out what I needed to change.

    Here's an example:
    =IFERROR(INDEX(Homework,SMALL(IF(Dates=D$8,ROW(Dates)),ROW(1:1))-TableRowStart,4),"")
    July 1, 2014 should say BIRTHDAY: Test, not just BIRTHDAY

    How should I fix the coding?

    Also, there are only 4 rows for each day in the calendar... is it possible to add in additional rows?

    I have attached the file that I'm working off of.

    I appreciate everyone's help! Thank you!

    Attachment 343317
    Last edited by nkicroft; 09-05-2014 at 02:44 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: IFERROR autopopulate code isn't bringing the right text from list tab to calendar tab

    Your attachment doesn't seem to work.

    Here's a link to some other calendar-related threads which you might find useful:

    http://www.excelforum.com/excel-gene...-calendar.html

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    04-12-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: IFERROR autopopulate code isn't bringing the right text from list tab to calendar tab

    Thank you Pete! I'm sorry for the delay in response, I was trying to read through the link you sent and the sublinks in there first haha This may take me some time! I appreciate your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autopopulate cell with list of data
    By Hansni in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-06-2013, 06:41 AM
  2. Replies: 1
    Last Post: 10-30-2012, 02:05 AM
  3. Autopopulate a List based on tab names
    By toddjesus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 06:15 PM
  4. list of names in one sheet autopopulate in another?
    By Jim Cronin in forum Excel General
    Replies: 2
    Last Post: 09-04-2012, 04:22 PM
  5. code to connect textbox1.text with calendar control selection
    By shankar.nstl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2011, 02:15 PM

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