I am a newbie in our forum and newbie to Excel too. I have a very difficult issues that I cannot solve.
Thus, I post it here and hope you guys could help me.
My issues is stated clearly in my attachment. Please have a look at it.
In fact, my problem is that I have 2 sheet:
1. Sheet 1 : Data base of employee by date and by code
2. Sheet 2: Table - form for user to key-in the new name of employee for a code and effective date
=> My question is how can we make the database could be automatically updated when the user key-in the changes in the table-form?
Please look at my attachment and help me to solve it. Many thanks in advances !