A macro to help me enter data per row and then drops down to the next row to input more.

Hi. I have a problem. I've attached an example to this thread for anyone to look at. My problem is this. I work in a department that wants me to manually enter data into cells denoting the hour it was input for that department on that day it was entered. The same goes for three other departments. There are 4 departments total. The spreadsheet is listing 24 columns from 0 to 23. Each column header refers to one hour. Every empty cell below is where I enter the data matching the department that is using that hour for the day. So each department does something for that day and this report I enter lists the actions for that department for the next 30 days. Each day I input that data into the day the work was done for each department stretching to 23 hours listed on a single row. This is causing me to get headaches and cross eyes because there's no way I can be sure I'd enter the correct information until it's all entered for the day and tallying up the totals to see if they match.

I need a better and quicker way to input these values into this spreadsheet by helping me generate a macro that allows me to enter the values for each department for that day and then after entering the information, the macro copies the data to the appropriate row and then clears the input row allowing me to input new data for a different department for that day and then repeats the same action. This would allow me to simply enter the data without double checking to make sure I input it correctly on the right row where I now have to enter manually.