Results 1 to 5 of 5

Excel Planner+ Calendar connected - Formula too long - don't want repeat on same date

Threaded View

RegularOfficeGuy101 Excel Planner+ Calendar... 08-03-2012, 06:45 PM
kvsrinivasamurthy Re: Excel Planner+ Calendar... 08-04-2012, 01:56 AM
Ace_XL Re: Excel Planner+ Calendar... 08-04-2012, 03:15 AM
RegularOfficeGuy101 Re: Excel Planner+ Calendar... 08-07-2012, 11:47 AM
RegularOfficeGuy101 Re: Excel Planner+ Calendar... 08-07-2012, 12:25 PM
  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    Salem, OR
    MS-Off Ver
    Excel 2010
    Posts
    3

    Excel Planner+ Calendar connected - Formula too long - don't want repeat on same date

    Hi,

    Hopefully someone can help. I have attached a file. The problem is that I want to enter information for a specific date on the general worksheet tab. Then, I want the calendar in the calendar worksheet to auto populate based on the data entered on the first worksheet. However, I don't want a specific date to repeat any of the same information. For example, if I want 10 different entries for July 1st, I want them all to show up on the calendar accordingly.

    I figured out a formula up to 6 entries, however when I followed the pattern to row 7, I get an error telling me that the formula has too many characters in it.

    So I'm hoping that there is a shorter formula or an easier process to figure this out to work around the situation. Any help would be greatly appreciated.

    PS -> I have no experience in VBA/Macros, so if there are any suggestions in that regard, I will need a lot of details of what steps to take. Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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