Anyone knows a macro that can sort earliest shift to latest shift?
I really need one
Anyone knows a macro that can sort earliest shift to latest shift?
I really need one
You can try recording a macro to do exactly what you need to start off.
Otherwise you will need to post a sample dataset and clear instructions as to what you want. A before and After would be ideal.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I've attached the sheet with a comment box describing what i need.
Is there also a macro that can pull the data from the punch data workbook to filled the columns with the specific headings highlight in blue?.
I've attached the after and before sheets with a brief description in the after macro tab.
really need your help.
Hi Shelly
You'll need a Custom Sort for this. You'll need to show me how you got from there to here. You'll need to show me ALL your available Shift Hours and how you wish them sorted.
Then, you'll need to tell me if the Code in this Thread worked for you or not.
http://www.excelforum.com/excel-prog...cel-sheet.html
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Should be able to work with the below... it creates a custom sort with the times you said you needed to sort by... I am not sure what you are wanting in the other two files.. if you can explain more I will help you out
Please Login or Register to view this content.
thanks guys much appreciated. thanks a million
Did you get it the way you wanted???
Yep its all good thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks