I have an existing excel spreadsheet that I would like to populate an excel calendar with- that spreadsheet is constantly updated so the calendar would need to update as well. i'd like the activities that show up on the calendar to be hyperlinked back to the spreadsheet as well.
Hello mzebell,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I have moved your thread to a new location, where it will get seen by helpers.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi, were you helped on this?
There are plenty of template calendars in Excel. I added one to the attached sheet as an example.
On your calendar sheet, you can enter this in cell A4 and copy it over, and then copy that row down to the other rows:
=IFERROR(TEXTJOIN(CHAR(10),TRUE,FILTER('data to polulate calendar'!$B$3:$B$38,'data to polulate calendar'!$A$3:$A$38=DATE(YEAR($A$1),MONTH($A$1),A3))),"")
On the template calendar, you can enter this in cell B5, and copy it across, and the down to the other rows:
=IFERROR(TEXTJOIN(CHAR(10),TRUE,FILTER('data to polulate calendar'!$B$3:$B$38,'data to polulate calendar'!$A$3:$A$38=B4)),"")
I did not work on hyperlinking them back to the task
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks