PaulF
Active Member
Hello all !!

I was asked to take a data set of resource names, business units, manager, and competencies / skills and put this into a format that would allow for multiple competencies to be selected and see who meets those requirements. This is for bidding purposes to see if we have staff that meets requirements. I added individual lookup, help, and some vba to copy results to the clipboard.
I know this is not the most sustainable format with names and XX's, but that is a larger issue for someone else to decide upon. I'm sure there are 1500 ways to do this, but this was my take.
I removed my company name, replaced all resource names, BU's, and Managers with faux data.
Enjoy, rip it apart, learn, comment... Ask questions and I'll do my best to explain my logic...
PaulF

I was asked to take a data set of resource names, business units, manager, and competencies / skills and put this into a format that would allow for multiple competencies to be selected and see who meets those requirements. This is for bidding purposes to see if we have staff that meets requirements. I added individual lookup, help, and some vba to copy results to the clipboard.
I know this is not the most sustainable format with names and XX's, but that is a larger issue for someone else to decide upon. I'm sure there are 1500 ways to do this, but this was my take.
I removed my company name, replaced all resource names, BU's, and Managers with faux data.
Enjoy, rip it apart, learn, comment... Ask questions and I'll do my best to explain my logic...
PaulF