I’m a quick learner but I have no experience writing VB scripts and very limited on Macros so forgive me in advance for my stupidity. Attached is how the data is given to me and in the second tab is how I actually need. There’s over 100 people I’m pulling data for and tips would be great.
Last edited by ollie81; 07-01-2013 at 03:23 PM.
Are there chances of having 2 shifts in the same data set for the same user? For e.g. Can Penny Baker have Shift 1 and Shift 2 in the same rows 10:14? In that case, what should be done?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
@Ollie81
Maybe you can explain why you want them converted from rows to columns?
Often we see the question to convert from columns to rows.
The reason for that question could be, to easily be able pivot table (which is a great tool for data-analyse).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
The shift will always be the same. We had a new time clock installed and unfortunately it doesn’t give us the same report as the old clock. So the current HR manager has demanded the data to be in the previous format. Obviously this would take hours with the 150 people we have working.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks