DenniBrink
New Member
- Joined
- Jul 31, 2016
- Messages
- 46
Greetings! I am looking for inspiration and problem solving skill involving best practices for data retrieval. I have a table listing employees scheduled days and work assignments. The table is organized as such:
<tbody>
</tbody>
Currently, I run a macro that filters out the "NS" and copies the names and assigned day. I wonder is there a better way such as pivotal table or a lookup formula. Please share your thoughts.
Name | Sat | Sun | Mon | Tue | Wed | Thu | Fri |
Bob | NS | NS | Clean | Inspect | Inspect | Clean | Clean |
Ed | Clean | Clean | NS | NS | Clean | Inspect | Inspect |
Rick | Inspect | Inspect | Inspect | Clean | Clean | Clean | Clean |
<tbody>
</tbody>
Currently, I run a macro that filters out the "NS" and copies the names and assigned day. I wonder is there a better way such as pivotal table or a lookup formula. Please share your thoughts.