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: 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 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.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Data retrieval

Thread starter DenniBrink
Start date Aug 4, 2016
Tags

best practice data retrieval filter lookup macro

DenniBrink

New Member

Aug 4, 2016

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:

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

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.