Hi all,

I hv a problem to merge calender.
I hv two sheets, 1st is to gather information about rental weather paid/ unpaid(using combo box paid; unpaid; excuse;new tenant...)
so on the 2nd sheet i hv a summary of information for each month.

Example sheet 1:
Name Hsz Number Status
Laura a12 Paid(using combo box)

Example sheet 2:
Name January February March............... December
Laura Paid Paid Paid Paid


I want the 2nd sheet automatically updated as i update the 1st sheet each month.

Please help me..anyone..(ASAP)

Thank you so much and Regards.

Leo