Have you ever recorded a Macro? Record a macro of copying the sheet (cut and paste tabs), and set it up with a Key stroke! see how far that gets you. Post back if you this is not desired, AFTER you have attempted.
Please, post the MACRO code here, so we can offer a complete solution based on what you already have!
Basically I'm wanting to fill out the rota table... then click a button and it transfer everything onto the time sheet table if that makes sense?
the tables are on different sheets
Karl
Please, post the MACRO code here, so we can offer a complete solution based on what you already have!