I have an excel spreadsheet in 2007, that has 20,000 contacts in, with names, job titles, addresses and email addresses.
I am wanting to take out, or copy certain job titles, say "Sales Manager" and move them into a new spreadsheet or file.
With the job title, also the relevant information to that person.
So, at moment the columns are like name, firstname, surname, address, company, job title, email address etc.
The rows are the individual contacts.
Is this possible, automatically as otherwise my eyes will pop out and manually will take weeks!