Copying a pasting specific columns

[Throughstream]

Hi I'm creating an annual leave document where a user would input values into sheet1 (Submitter) on row 17 under the headed titles "Date requesting etc etc" so * B17-S17, they would keep filling in the rows beneath say to row 27. They would click submit (command button) and the values would be copied to rows 4-14 under the same respected headers "date required" etc on sheet 2 and exsactly the same with sheet 3.

The values would then be deleted off sheet 1 ready for the next user but remain on sheet 2 and 3. .

When the second user uses sheet 1 the values would be copied to Sheet 2 underneath the values of the first users data and the same with sheet 3.

* The only thing to add is I only want to copy over the values under the headed titles on show from sheet 1 so b17 for example but not f17 as that's a hidden column.


If if this makes no sense I can do some pictures to explain.

Seperate.
In in a separate if possible kind of way can I have a separate vba code to do the same as above but instead copying and deleting to sheet 2 and 3 send it to another document altogether, the second document would be identical to the headers as sheet2

Any help would be most appriciated.


first sheet.jpg

seconds sheet.jpg

back up.jpg

[Throughstream]

Admin please delete as this is being moved to the paid subscription.