We have an excel file that consists of about 80,000 entries that can be defined by about 2500 categories. eg there are 1000 doctors on the list, 700 dentists, 300 yoga teachers etc
We have assigned each category a number, eg doctors are category 1, dentists are category 2, yoga teachers are 3 and so on.
Our clients will select a bunch of categories and send them to us. For example, a client might send us an email and say they want 1 and 3 (doctors and yoga teachers.)
Our clients will usually send us about 50 categories which makes it time consuming for our staff to go through the master list and pull out those 50 categories, so we want to automate it.
I want to use excel to be able to extract the required data.
I want to be able to input the category numbers ALL AT ONCE, eg 1, 3, 15, 16, 45, 333, 567, 978 etc and have the system create an Excel file containing the 700 dentists, 300 yoga teachers etc.
The file we have is about 20 columns wide, so we need all 20 columns to come out in the Excel file.
When we input the category numbers do we need to separate them with a comma?
We cannot provide you with the database (a sample is ok) so we need to be able to upload the database into the system you provide ourselves.
We have 10 separate databases, so we need to be able to do this 10 times.
December 23, 2017
I am willing to pay higher rates for the most experienced freelancers