Previous Topic Next Topic

Moving information from one table to another

Closed
karlkeegan Posts 2 Registration date Tuesday December 20, 2016 Status Member Last seen December 20, 2016 - Dec 20, 2016 at 06:16 PM
 Blocked Profile - Dec 20, 2016 at 07:36 PM



I need to move data from one table to another, then loop back through until all the information has been moved, I suck at vba code etc...

can anyone help please??

Karl

1 response

Answer 1 / 1
Blocked Profile
Dec 20, 2016 at 07:18 PM
With what variable do we move it? Does is all go to the same sheet?
0
karlkeegan Posts 2 Registration date Tuesday December 20, 2016 Status Member Last seen December 20, 2016
Dec 20, 2016 at 07:31 PM
Hi there,

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
0
Blocked Profile
Dec 20, 2016 at 07:36 PM
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!
0