save data to another sheet via command button
I have a userform that causes results to be entered in various cells on a sheet called "TouchPaddata".
On the same userform, I have a button that I would like, when pressed, to send the values in some of those cells to specific cells in another sheet called "1st Qtr", some to be sent to the sheet "2nd Qtr", others to "3rd Qtr" and others to "4th Qtr".
The cells in the original sheet "TouchPaddata" will then be cleared, ready for use for the next new Football Game.
Is this possible or is there a more sensible way of keeping data from a sheet that needs to be cleared each week ?
I have a userform that causes results to be entered in various cells on a sheet called "TouchPaddata".
On the same userform, I have a button that I would like, when pressed, to send the values in some of those cells to specific cells in another sheet called "1st Qtr", some to be sent to the sheet "2nd Qtr", others to "3rd Qtr" and others to "4th Qtr".
The cells in the original sheet "TouchPaddata" will then be cleared, ready for use for the next new Football Game.
Is this possible or is there a more sensible way of keeping data from a sheet that needs to be cleared each week ?
Last edited: