Good Afternoon,
I have attached a file for reference. I would like to click a button that transfers the pertinent information from the "current" tab and move it to the "compiled job data-after" tab. There is also a "compiled job data-before" tab that is blank. I have header columns on the "compiled after" tab in row 2 that I would like the data to move from sheet to sheet. The carpenter #4 would be a manual enter from me. I would ideally be using this everyday to email out the carpenter schedule so as jobs complete I would like them to fall off the report when click the update button.
I'm sure I've left some stuff out that could be helpful (I don't want to be too confusing) but please ask me.
Thanks.