You don't really have to specify the day in columns C or E in the first sheet, as this can be done with a formula, e.g. with this in C8:
=IF(B8="","",TEXT(B8,"ddd"))
and this in E8:
=IF(D8="","",TEXT(D8,"ddd"))
Copy those two formulae down as far as you think you might need.
As for the other sheet, is there any particular order that you want the items from Sheet1 to appear in? If you want to retain the colouring for English and Chinese, it might be better to have another column for "E" or "C", so that you can easily see where the data has come from. Are you likely to want to enter a range of dates in Sheet1 (i.e. from start_date to end_date), or is a single day's entry for each event sufficient?
Pete
Bookmarks