Code to copy paste data from one sheet to other sheet in the same workbook

[VanshLucifer]

I am creating a break calculator which will help user to keep a track of his login hours and break time.
I have already created a the excel file
Please find below the format.

DATE	08/01/2018
Login Time	09:30:00	Logout Time
Break Slots	Start Time	End Time	Total Login
15 Min slot			00:00:00
15 Min slot			00:00:00
30 Min slot			00:00:00
Bio break			00:00:00
Bio break			00:00:00
		Total Break Time	00:00:00
		Total Login	###########
		Actual login Time	###########

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

It should not copy the entire numbers just the below details

DATE

LOGIN TIME

LOGOUT TIME

TOTAL BREAK TIME

ACTUAL LOGIN HOURS

DOWNTIME

<tbody>
</tbody>

The pasting range strats from B2 to G2

I need a VBA code to which will paste the above details in the other sheet
I will be pasting data at the day end i have already created vba whcih will take date from the system.
i just need the code to paste to the other sheet.
and it shld not over right data for every new date it shloud paste data in the below cell
say for example it for 8th jan it pasting the data from B2 to G2 range
for 9th jan it should paste data from B3 to G3 range.

urgent help required.

Please help.!!

 

[frank_AL]

Re: Need a vba code to copy paste data from one sheet to other sheet in the same workbook

Yes on the surface I believe that is doable. Create it as a new post and provide examples of the various scenarios. After you create it, add the post name to this post so I can find it.