Forum Discussion
dynamic excel calendar help pls
hi Rachel
Thank you is there any way to auto populate the text from any other tab that match the date in the calendar?
to display eg Title, Category , Start to end date / time.
Attached sample tab , event data start and end time are from SP which contain Date and Time, but how to use Text Join to match it to the cal date and display across if it run few day? Thank you
Yes, you can use Filter to put event next to date which is greater than start date and less than end date:
hi Rachel,
Thank you but what is HSTrack?
I notice that u Run the event A to F, if I want to pick from selected columns, not all the columns Text, how to as the real data is very big. Thank you
Thank youHSTACK stacks columns horizontally.
e.g if you want to include column A and column F, you can use
=HSTACK($A:$A,$F:$F)if you want to include column A, B and F, you can use
=HSTACK($A:$B,$F:$F)hi Rachel,
Great it works.
. One last question, the text are display as a string of text, is there anyway to break it into next row
event -bold title
confirmed
XXX
add Status : the data fr the list?
Also anyway to color format the item by it Category? Thanks
Thank you
