Code to copy from worksheet to another

[Oly Steel Man]

I have a sheet we are developing to do some simple time tracking. We want to enter on one sheet then basicly archive to another for some analysis later. I have a code from and older sheet that copies certain cells from one sheet to the next. It's very crude but works. I need to copy many more than my current code allows and I'm not sure even how to begin to do that. I had an idea of how but when i got into it more i ended up with 200 plus lines of copied code which sent my sheet into oblivion. So I'm appealing to the masses for someone to guide be in a much better direction. I've attached a sample of the sheet for reference. The main idea being we imput on the time sheet then run code to export and store on the collection sheet. Many thanks in advance!

Old code I used was:

Please Login or Register  to view this content.

[watersev]

hi Oly Steel Man, please check attachment

[Oly Steel Man]

@ watersev

Seems to work well, thanks! I'll continue to test it with random samples of data. Very appreciative of the input!