Excel Row Selector Tool

Proyek ini berhasil diselesaikan oleh vkalach dengan harga $60 USD dalam 3 hari.

Dapatkan penawaran gratis untuk proyek seperti ini
Anggaran Proyek
$10 - $90 USD
Diselesaikan Dalam
3 hari
Total Penawaran
Deskripsi Proyek

We need an Excel macro which does the following: we have many spreadsheets, as many as 100, with lists of names, work titles, work department and email. The macro needs to find certain keywords in one of two columns (it must search both columns) and then select the complete record and export it to a separate spreadsheet. We need to be able to find a range of keywords. For example we might say, find all records with any of the following words in the specified columns: biology, medicine, pediatrics, psychiatry, healthcare, etc. etc. We also want an exclusion feature if possible. For example, we would like to say, find records with any of the keywords listed but exclude records with the following terms: part-time, consultant, adjunct, etc etc. Finally, we want the macro to search one spreadsheet after another and so we need some form of panel to specify which spreadsheets to search. All of the spreadsheets can be in one directory if this helps. Most single spreadsheets are a few thousand records but some are as large as 10,000.

Diselesaikan oleh:
Keahlian yang Diperlukan

Ingin menghasilkan uang?

  • Atur anggaran Anda dan jangka waktunya
  • Uraikan proposal Anda
  • Dapatkan bayaran atas pekerjaan Anda

Pekerjakan para freelancer yang juga menawar di proyek ini

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online