Hi everyone...

Here's a tough question.

I have started my own recruitment business and rather than paying for a CRM I've started modding a spreadsheet.

It's quite a powerful tool for sorting and mailmerging etc but I'd like to add a very advanced level of functionality to it, with your help.

I keep all of my candidate's CVs in a folder. I can search the word documents in that folder using the windows search bar for multiple terms.

Each of the CVs is hyperlinked to the spreadsheet for easy access.

I'd like to be able to search from my spreadsheet database to be able to shortlist candidates without having to go to the folder and sorting documents as a further and much longer step. I have thousands of CVs.

Anyone think they can solve this problem?

Thanks in advance for thinking about it!