Thanks for any help , it is needed, i have searched and tried to find some code to make my own but have no luck so i am looking to this forum yet again for help.
So what i am looking to do is to simply copy values of a cell and paste the value in another cell on a separate work sheet using checkboxes in a multipage userform attached to a command button, it is used to check a person in our out , it will copy from a "Daily POB" and paste in a "Arrivals-Departures" sheet there are 2 different series of columns on the arrivals-departures sheet one being arrivals and the other being departures , so in the user form i will have a multipage box pop up page 1 will be arrival and page 2 will be departure , and in each page will be 62 check boxes and when you check for example #1 it will copy and paste the value of the name of the personnel associated with that number on the POB to either arrival/departure in the arrivals/departures sheet , now the part that is evading me is how to make it paste the values skipping non empty cells and pasting to the next empty one .
so for reference for check box #1 i want to copy the value of cell C3 on the sheet labeled "Daily POB" and paste to the next empty cell on sheet labeled "Arrivals-Departures" in a range of cells C5:C49
any help is appreciated , if more info needed i will do my best to provide it, thanks in advance.
So what i am looking to do is to simply copy values of a cell and paste the value in another cell on a separate work sheet using checkboxes in a multipage userform attached to a command button, it is used to check a person in our out , it will copy from a "Daily POB" and paste in a "Arrivals-Departures" sheet there are 2 different series of columns on the arrivals-departures sheet one being arrivals and the other being departures , so in the user form i will have a multipage box pop up page 1 will be arrival and page 2 will be departure , and in each page will be 62 check boxes and when you check for example #1 it will copy and paste the value of the name of the personnel associated with that number on the POB to either arrival/departure in the arrivals/departures sheet , now the part that is evading me is how to make it paste the values skipping non empty cells and pasting to the next empty one .
so for reference for check box #1 i want to copy the value of cell C3 on the sheet labeled "Daily POB" and paste to the next empty cell on sheet labeled "Arrivals-Departures" in a range of cells C5:C49
any help is appreciated , if more info needed i will do my best to provide it, thanks in advance.