schedule.xlsxI am looking for a fairly easy way to find employees who are available to work a certain hour of a certain day without manually filtering. I'd like to attach some method to a macro but I can't figure out a method. Lookup? Index? Pivot table? Advanced filtering? Ideally I could ask the sheet for employees available on Wednesday at 5:30 for example. I'm novice but technical ... just don't know insanely advanced formulas.
Thanks
Last edited by jhiltabidel; 03-28-2013 at 09:15 PM.
It might be easier to help you if you included a sample workbook (without any sensitive data), showing what data you are working with, a few examples of your expected outcome, and how you arrived at that?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Just added it, thanks
Last edited by jhiltabidel; 03-28-2013 at 09:15 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks