So, I have 2 sheets. Sheet 1 has details of grades of class students. There's a submit button. I need to assign a macro to this button that will copy the data from sheet 1 and paste it in sheet 2 in respective columns. So, every time you punch info in sheet 1 and press submit button it should add a new line item in sheet 2 table. May need to paste special values so that when to enter new info in sheet 1 data in sheet 2 gets entered in next row.
Code should also enter the date on which submit button was pressed.
Bookmarks