Hello:
Please refer to attached file.
Name of Sheet "Source" and "Dest"
I have data in this sheet from row 600 column A:D down as shown. (Diff Date)
I need VB Code to rearrange the data as explain below.
Choose the first data cell A600, enter that date at "Dest" Cell A2.
Enter corresponding employee name in cell B2, 1st ClockIn in cell C2, 2nd clockin in cell D2 and so on.
I have manually done this in sheet "Dest", please have a look.
Let me know if you have any questions.
Thanks.
Riz
Hello Riz,
Do you want the data to overwrite any existing data on the Destination sheet?
Do you want a blank line between dates on the Destination sheet?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith:
Overwrite existing data..
No blank lines
Please let me know if you have any questions.
Thanks.
Riz
Hello Riz,
This macro has been added to the attached workbook. It will organize the data as you requested. To run it it use the ALT+F8 keys to choose from the list. Of course, you can always attach it to a button.
Currently, the macro is set to a maximum of 5 Clock-In/Out periods per employee. This can be changed if needed.
Please Login or Register to view this content.
Hi Leith:
Thanks a lot......works super
Would it be possible to add total hours worked in column M of DEST sheet.
(Note : (ClockOut1-ClockIn1 + ClockOut2-ClockIn2+ClockOut3-ClockIn3 and so on
Riz
Last edited by rizmomin; 03-29-2016 at 11:16 PM.
Hello Riz,
That was a fast response! You're welcome.
Hi Leith:
Would you please help again on this thread.
The Source Data would not have any blank rows, so please help modify the code so that it does the same function.
Thanks
Riz
Hi Leith:
Never mind, got help from AB33.
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks