Ditutup

Automated Data Entry Excel

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.

Kind regards,

Keahlian Entri Data, Pemrosesan Data, Pemrograman Database, Excel

Lihat lebih lanjut: excel entry data form, excel autorefresh data entry sheet, excel create data entry sheet, company requiring excel offline data entry work, excel spreadsheet data entry, excel 2000 data entry macro, excel simple data entry, excel double data entry, urgent excel product data entry, access excel purchasing data entry, excel macro data base entry, excel remote data entry, free microsoft excel customer data entry

ID Proyek: #12702119

19 freelancer menawar pada rata-rata $176 untuk pekerjaan ini

jaylancer43

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 Lagi

$250 AUD dalam 5 hari
(389 Ulasan)
7.7
$150 AUD dalam 1 hari
(250 Ulasan)
7.6
cgullapalli

Hi, I am good at Excel and vba. Plz provide me the excel file details further. Looking forward to discuss in the chat.

$250 AUD dalam 5 hari
(324 Ulasan)
7.1
mirniyazuddin92

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 Lagi

$150 AUD dalam 3 hari
(188 Ulasan)
6.8
Dhruvika111

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 Lagi

$88 AUD dalam 1 hari
(227 Ulasan)
7.4
cugamelover

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, Lagi

$120 AUD dalam 3 hari
(145 Ulasan)
6.8
dpune

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 Lagi

$200 AUD dalam 3 hari
(159 Ulasan)
6.3
schoudhary1553

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 Lagi

$110 AUD dalam 2 hari
(89 Ulasan)
5.9
SigmaVisual

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 Lagi

$222 AUD dalam 10 hari
(33 Ulasan)
6.0
kevivu

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 Lagi

$200 AUD dalam 3 hari
(68 Ulasan)
5.7
sonarkaushik

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. Lagi

$156 AUD dalam 3 hari
(92 Ulasan)
6.1
fanninson45

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 Lagi

$333 AUD dalam 3 hari
(11 Ulasan)
5.4
ksriniravi

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 Lagi

$130 AUD dalam 5 hari
(35 Ulasan)
4.9
renesontiongson

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.

$100 AUD dalam 3 hari
(34 Ulasan)
4.7
The24CarrotsInc

A proposal has not yet been provided

$61 AUD dalam 1 hari
(18 Ulasan)
4.2
mohamedrdait

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

$222 AUD dalam 3 hari
(6 Ulasan)
3.6
archanaoswal

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 Lagi

$200 AUD dalam 5 hari
(10 Ulasan)
3.5
vivirain

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

$250 AUD dalam 5 hari
(4 Ulasan)
2.0
$155 AUD dalam 3 hari
(0 Ulasan)
0.0