The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We have two excel spreadsheets. One has a small amount of data and one has a large amount of data. We need to parse the one with the large amount of data and extract an email address and phone number when certain parameters are matching on the two spreadsheets adding that extracted info into the spreadsheet with the smaller amount of data. Preferably need a tool or script that can do this on a regular basis as there may be more files that the same thing needs to be done in the future.
Added 3 JUN 2012, 13:45 PM EDT
Attached are two sample files that we will need to be using.
We need to start with 2010 IRS ERO Data (09 Tax Yr)-Master.xls and take the name in the contact column and then pull the email address(s) and phone number(s) from the file NY-PTIN-my-areas-actual.xls that have that contact name associated with it.
Please note, the file NY-PTIN-my-areas-actual.xls has data in different columns and is not perfected so your parse cannot b...
Sign in or Register to see more