I have an Excel file that has a list of U.S. hospitals (first worksheet of Excel file). Each hospital has a unique ID (second worksheet of Excel file). I need someone to link the hospitals in the first worksheet to the second worksheet in order to populate the "Provider Number" field.
I started to do this manually and realized a database programmer could do it more efficiently by writing some queries. Here's my logic:
1. Match by hospital name, address, city and state
2. If address, city and state are not available, research by phone number.
3. If #1 and #2 aren't available, then look at domain name within email address
The project objective is to try and populate as many of the blank Provider Number (Column C) fields in the first worksheet.
Décerné à :
Using Excel and managing data is critical for my job, so am proficient with formulas and additionally can code. Am confident to do the query you require. Looking forward to hearing from you!
16 freelance font une offre moyenne de $112 pour ce travail
Hi, i'm a professional C# programmer, and i can provide you with a C# program with Access backend so you can manage your hospitals easily, please let me know if you are interested, thanks.
Greetings! I am an expert PHP and database programmer and I can match the hospitals as per your criteria and populate the required field within hours. Please allow me to pursue another project and prove my worth.
Hello dear, yes it is possible for me. i have good skills in database. i have checked your attached file. can do this... contact me so that we can proceed.... Thanks and have a nice day
Hi there! Have done this type of work before and am an excel/data expert! Please feel free to message me with any additional information or with questions if any! Thanks! -Steve