Copy info from one excel sheet to another sheet

sstanger Posts 3 Registration date Wednesday December 10, 2014 Status Member Last seen December 12, 2014 - Dec 10, 2014 at 12:56 PM
I have sheet 1 that i call "FORM" that I enter information into. I would like to create a macro to copy the info that i put on the FORM onto sheet 2 "LOG". When moving the information from the FORM to the LOG, I want it to log it in order. Then after it is entered into the LOG, i would like to protect the LOG so that it cannot be changed until the end of each year. I would also like the FORM to print after i press a command button on the FORM to enter the information on to the LOG.