Find Jobs
Hire Freelancers

Excel data tool

$30-250 SGD

Closed
Posted about 5 years ago

$30-250 SGD

Paid on delivery
Hi, I need an excel tool My project looks very simple for someone who know excell. I have many files of lists of clients extracted from 6-7systems, and for each clients I have an ID number. I need to do an Automatic research from thoses 6-7 systems, and excell give the result when the ID refer to a client in the 6-7 Systems. So it will be especially Pivot Table, and Vlookup. ( The best would be a VBA) thanks you very much. regards,
Project ID: 18674183

About the project

92 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
92 freelancers are bidding on average $126 SGD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$150 SGD in 2 days
4.9 (367 reviews)
8.0
8.0
User Avatar
I would like to suggest to you a Microsoft Excel application which enables you to manage databases of records in a spreadsheet. The app allows you to import records from external files and conduct a central database with the records. Also, I can add a search engine with high search capability to find specific records. During the reporting process, Excel validates the information and prepares reports and documents (by Pivot Tables)based on the needed parameters and criteria. There is a report generator which enables to develop templates independently. I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. Furthermore, I have experience in dashboards, financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation. With these skills, I develop financial modules with incorporate complex components of business in a simplified and logical manner.
$250 SGD in 3 days
4.9 (90 reviews)
7.1
7.1
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
$150 SGD in 5 days
4.9 (250 reviews)
7.0
7.0
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Ok. Sure. I will employ VBA to do the vlookup and result creation. Willing to take up your project. Thank you, Regards.
$155 SGD in 3 days
5.0 (120 reviews)
6.4
6.4
User Avatar
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you for further discussion. Kind regards Rina
$155 SGD in 3 days
5.0 (105 reviews)
6.2
6.2
User Avatar
Hello, I am Excel and VBA expert. Could you give more details and send the sample files? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan
$133 SGD in 3 days
5.0 (98 reviews)
6.1
6.1
User Avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a POS and inventory management system - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a hotel price comparison that pulls data using the website's API - Scrape various websites like tennisinsight, pubmed You can see the reviews of the same in my profile Thanks, Archana
$150 SGD in 3 days
4.8 (92 reviews)
6.0
6.0
User Avatar
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I suggest you to use VBA Programming that will give you extensive and flexible functionality and more accurate and specific results. I can create vba program to achieve your goal. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$250 SGD in 3 days
4.8 (99 reviews)
5.7
5.7
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$100 SGD in 3 days
4.7 (70 reviews)
5.7
5.7
User Avatar
Hi, I can successfully finish your project either with pivot tables and formulas or with VBA scripts. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets) as an Industrial Engineer at Michelin Romania . I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$150 SGD in 3 days
5.0 (22 reviews)
5.3
5.3
User Avatar
Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$100 SGD in 3 days
4.9 (74 reviews)
5.5
5.5
User Avatar
Hi, I am an excel vba expert and i went through your project description. I have worked on many similar projects like these where a single database is created by extracting data from multiple locations. Going through your problem, we would first want to create a setup where the data automatically gets stored in the database by a click of a button. Even when new data is updated in the 6-7 sheets, the database will continue adding data from the last update. Then we would need a search bar where you can search for any client from the database based on different conditions. Thanks Sajid
$133 SGD in 3 days
4.3 (69 reviews)
5.8
5.8
User Avatar
MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
$49 SGD in 2 days
5.0 (42 reviews)
5.1
5.1
User Avatar
Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some automation and scraping, scientific scripts. I can help you to automate excel file. So I think I can help you in your project. Just let me know if you want start job. Regards. Lian
$150 SGD in 3 days
4.7 (13 reviews)
5.2
5.2
User Avatar
Hello. I have recently completed very similar project using VBA with 100% positive feedback : https://www.freelancer.com.ru/projects/project-18646362/ Your task can be completted during 1 day.
$90 SGD in 1 day
5.0 (28 reviews)
4.6
4.6
User Avatar
Hi Good Day! A serious freelancer here! I can help you to complete this project in 3-4 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. Please accept my bid and I promise to show you my expertise. I am a VBA macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$50 SGD in 4 days
4.9 (42 reviews)
4.6
4.6
User Avatar
Hi, I would to offer my services for your project Excel data tool. I am an India based accountant having more than five years experience and also expert in Microsoft Excel including complex formulas and VBA or Macros programming & development. I am having experience in Global Accounting and Taxation as well. Most of jobs which I have performed so far are for the clients/employers based in India, US, UK, UAE, Australia,New Zealand. I perform variety of job including following:- *Bookkeeping *Accounting *Taxation *Payroll *Financial statements *Financial modelling/Projections/Forecasting *Business Plan/Business writing *Process Development *Dashboard Development *VBA or Macros development *Data Processing/Data Extraction/Data Entry I am having working exposure and experience in numerous accounting software such as:- *Xero *MYOB *QuickBooks *ZohoBooks *Tally *Banana *SAP *Odoo I am also having good experience in Accounting Software implementation and integrations job. Looking forward to a successful cooperation with you. Kind Regards Gopal
$100 SGD in 3 days
5.0 (15 reviews)
4.6
4.6
User Avatar
I can do the job. I would use mostly VBA unless pivot table or standar formula are more suited. What file format do input data come in, excel? I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, MS Project, Autocad etc.), web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6.
$75 SGD in 4 days
5.0 (21 reviews)
4.2
4.2
User Avatar
Hi, Any updates from you regarding this project? Kindly send me the details Thanks regards Thushara
$155 SGD in 3 days
5.0 (29 reviews)
4.4
4.4
User Avatar
This is what I propose to you: * You can enter as many client IDs as you want to check. * You can configure the tool to look in any number of files. * Once you have input the IDs, you can click on the "CheckIDs" button to have a report of whether the ID is found or not and in which file. Question: * What is the format of the files? Assumption: * The files have the same format and in text format. Schedule: * The tool can be built over the weekend using Excel and VBA. Looking forward to hear back from you as I would like to share a screenshot with you on how the tool will look like. --- My experience and past works: * 12+ years in IT as a developer, technical lead and business analyst * Please check my freelancer.com profile for more positive referrals.
$110 SGD in 2 days
4.9 (14 reviews)
4.4
4.4

About the client

Flag of HONG KONG
Central, Hong Kong
0.0
0
Member since Feb 7, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.