1383
« on: November 03, 2011, 03:36 PM »
thanks for your reply
my requirements are nothing more than what I mentioned in my previous post, I mean, I exactly and only do what I mentioned previously
if you have any specific question, I will be glad to answer
I was thinking to use an "append" function or macro, but I don't know how to start
the target cells appear to have date format in the screenshot, but this is not necessary imo, there will be no problem them being simple text
but the "calculated dates" must be in date format, because they will update according to the date I have set as "today date"
in simple words, the script/macro or whatever, will have to take "my text" and append it to the correct calendar cell
it would be really nice if inside the calendar cells (that will contain the date at top and the appended text at bottom), the date is highlighted, formated or somehow distinguished from the other text below, so that it would be easier to the eye to see which text correspond to which date
or maybe each date cell in the calendar should be splitted into two cells, one containing the date only and the other (below) containing the appended text
last, a shortcut or button preferably should trigger the data migration/binding across the cells (from source "my text" cell, to target cells of the calendar, with calculated dates as pointers)
thanks