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!
Bookmarks