VB Code to reorganize data

Hello:

Please refer to attached file.
I have data as shown from Column O onward.
Each days clockIn-Out data for each employee is as shown and occurs every 4th column until Column EE (31st)
I need VB Code to reorganize this data in Column A thru D as shown starting at Cell A3

Let me know if you have any questions.
Thanks.

Riz

Hello:

Can someone have a look at this.
Thanks

Riz

Hi Leith:

This works great, thanks.
Now assume, i have date in Cell K1.
I need a separate code just to paste for this particular date with the same logic as you have done.

Just 1 day of data.
The reason is that i have lots of Monthly data which i can use the above code but going forward i can use new code for just 1 days data (Faster).
Please let me know if you have any questions.
Thanks.

Riz

Hi Leith:

I am having small issue with the code with my data.
Please see attached pic which shows where the data needs to start.
In my file, date will be at Row 599.
Start pasting at A600 down.

Please let me know if you have any questions.
Thanks.

Riz

Hello Leith or someone:

Please ignore #5 above, i have resolved.
I need help with #4.
Please let me know if you have any questions.
Thanks.

Riz

Hi Leith:

Please ignore #5 above as i was able to modify code to take care with my data.
However, as i have mentioned in #4, i want to do the same for single date which will be in cell K1.
I have completed whole month, now going forward i would like to add the code so that it will paste at last row in column A.
Please let me know if you have any questions.
Thanks.

Riz

Hi Leith :

Yes, output will be in column A:D as usual.
Thanks
Riz

Hi Leith:

Small problem.
It is overwriting at cell A3.
Basically once i start using then obviosly column A:D will have data until Today()-1.
Now Today() comes so new data needs to be pasted after the last data in column A.
I hope this is clear and please let me know if any questions.
Thanks
Riz

Hi Leith:

I was able to edit the code for my need.
Once again thanks a lot and will contact if further issue.
Thanks
Riz

Hello:

Thanks a lot for such a great help to Leith and Winon.

Very impressive work.
Riz

Hi Winon & Leith:

Would like 1 more feature on this code if possible.
Instead of pasting the data to the next blank row, would like to paste every 50 rows.
So basically for 1st of the month, start pasting as 600, 2nd of the month 650, 3rd of the month 700 and so on.
Please let me know if you have any questions.
Thanks.
Riz

Hi Leith:

Thanks a lot...i need to make sure the date in cell K1 is compared in Row 599 only and pick up the data from that location cloumn Row 600 down.
Please let me know if you have any questions.
Thanks.

Riz

Hello Leith:

Please refer to attached file.
This is from my actual file.
I will have date in cell C1
Now go down to row 599.
This row will have date and data.
I will need the data in Column A:D from row 600 down.
Allocate 50 rows for each date.
Example :
Row 600 to 649 will be for 3/1/2016
Row 650 to 699 will be for 3/2/2016 and so on.
Row 700 to 749 will be for 3/3/2016 and so on.

Now depending on the date in cell C1, lookup the data ot match the date.
Lets say Date in C1 = 3/3/2016
In case paste the data from cell W600:Y649 and paste at B700 but add 3/3/2016 in column A (Cell A700 down until data for the day)

Please let me know if you have any questions.
Thanks.

Riz



Let me know if you have any questions.
Thanks.

Hi Leith:

You are Super excellllllllllllllllllller.
Thanks a lot for great help
Riz