I am seeking an expert Excel user to do some VBA Macro work on my current excel document.
The document is for a recruit agency.
The concept takes public data from [url removed, login to view] and order it into columns in excel that can be reviewed. It is like a search engine.
This will help us see how many ads are on seek by other recruitment agencies or private businesses
I have attached an Example document. (Example only)
If you go to [url removed, login to view] you can see they say "Keyword", "Choose Classification" then it is broken down into Sub-Classifications, then a "Enter Suburb, City or Region"
I need the user to be able to choose a classification in A2, (i have done this with a simple list), then choose a Sub Classification in B2 (from A2's option) Refer to this link for all the classifications and sub classification. [url removed, login to view]
Next the user needs to enter their area form the given list.
Once the filters have been filled in (noting not all need to be filled in) the user presses the RUN SEARCH button and we get 3 sets of data from the search.
1) The Role Title
2) The Company Posting the Ad
3) Is it a Private Company or Recruitment Agency. ( See the list of agencies here - [url removed, login to view]) Please note this list does not include all of the recrutment agencies out there and i would like to add the list when need to. So, if the list could be in a separate sheet and the macro checks if the name is there. if it isnt it will say No and if the name is in the list it will say Yes.
Then i have put a title called "Make-up" and this will have a count function counting how many of the results are recruitment agencies or private.
All the information needed to create this output can be found on the search page, no need for the macro to go into each ad.
I understand that was alot of information. I can explain further if you have any question.
Refer to the attached to see what i mean.
19 freelance font une offre moyenne de $176 pour ce travail
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Plus
Hi, I am good at Excel and vba. Plz provide me the excel file details further. Looking forward to discuss in the chat.
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information Plus
Greetings! Proper Communication and a small samples before starting a work is the most important key to complete the project successfully , since its the most important parameter it has to be easy and clear. For thi Plus
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Plus
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, Plus
Dear Client, I can help in your project. I have already experience of working on similar projects. I am expert Data Scientist and have expertise in data mining, web and data automation, I can develop automated b Plus
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Plus
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus
Dear Sir, I am based out of Jersey City, NJ, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and Plus
SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Having the ability to take the technical lead in p Plus
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Plus
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me t start the job. Thank you so much.
Hello sir I can achieve the project perfectly and automate the process by create a desktop application for windows os please contact e for more details best regards
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a reservation system - Built a complex shift allowance c Plus
Hi, I'm interested in the job. I have rich experiences of Excel VBA macro programming and can help get it well done. Feel free to contact me and discuss more details. Best Regards, VL