So my Calendar is almost done there's just one little thing i can't figure out.
Let's say in Sheet1 I've got information in two different cells, a date(C10) and in the other cell what is going on, on this date(B10)
Business Trip.PNG
And in Sheet2 my calendar. Just a horizontal list of all business days in a year.
What i've already achieved is that when i type in the Date in Sheet1(Events)the whole column gets highlighted. (Thanks to a post earlier)
Highlighted Column.PNG
Now my question is how can i automatically insert the Text from Sheet1 B10 into all Highlighted cells row 4-25?
Can this be done with VBA or can i configure this in CF?
Im thankful for any piece of advice
Joel
Bookmarks