Find Jobs
Hire Freelancers

Build an Excel scrip

$15-25 USD / hour

Zavřený
Zveřejněno před více než 4 roky

$15-25 USD / hour

We would like to build a scrip that imports a list of fields from an Excel spreadsheet , fills out the Excel spreadsheet, apply the formulas inside the Excel , create tabs for each year with the same formulas and creates a summary tab. Here are the directions: 1. The end user will fill out the “import List” tab 2. The scrip will analyze the data in the "import tab", create a tab for each year (in the example, there are two years: QBAI2010 and QBAI 2011) based on the date of the item. 3. The scrip will pick up the details from the import list and place in the relevant tab based on the year. For example, all of the asset from 2010 will be placed into the QBAI 2010 tab and all of the asset from 2011 will be placed into the QBAI2011 tab 4. Inside the Excel there are all of the formulas that we would like to achieve for each year. The tab QBAI2010 is already fill out with the formals. Please do the same formals for the rest of the tabs: QBAI 2011, QBAI2013-QBAI2018. In other words, QBAI 2010 should be mimic for each year data. 5. The scrip will create a summary based on the Summary tab. I have attached the Excel as an example
IČ projektu: 20939532

O projektu

32 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
32 freelanceři nabízejí v průměru $20 USD/hodinu za tuto práci
Avatar uživatele
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
$18 USD v 40 dnech
4,9 (397 recenze)
8,1
8,1
Avatar uživatele
Hello. How are you? I have rich experience with Excel SpreadSheet. Please kindly check following my previous works related excel spreadsheet. https://www.freelancer.com.au/projects/php/Project-for-Yanying-20420141/reviews https://www.freelancer.com.au/projects/javascript/Javascript-CSV-files-Jquery/reviews I am a serious bidder and I am very clear what you want. I have reviewed the xlsx file you attached. I hope to work with you because my skill set is suitable for your project. Will wait patiently for your favorable reply. Thank you.
$20 USD v 40 dnech
4,9 (105 recenze)
7,9
7,9
Avatar uživatele
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$22 USD v 40 dnech
4,9 (164 recenze)
7,7
7,7
Avatar uživatele
Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using diff tools like .NET, Excel and VBA, Winautomation, etc) and I'd like to help you. Please, get in touch to discuss and understand all the details in deep. Based on what we will talk, I'll be able to give you a good proposal. Experience building solutions like: Windows Desktop Apps (using Excel and VBA, Access and VBA, .NET,C++,C#, Winautomation) Scrapers Apps Scrape services Automation programs/bots Web apps/systems. Message me to have the whole idea about your project. Will wait for your contact. Thanks.
$25 USD v 12 dnech
5,0 (217 recenze)
7,5
7,5
Avatar uživatele
I'd be happy to help you on this interesting project, and I can also give you a fixed price offer if you prefer to do it that way. Let me know. . .
$22 USD v 20 dnech
4,8 (269 recenze)
7,7
7,7
Avatar uživatele
Hi Nice to meet you. I have built so many python scripts for automation works. I checked your attachment. Also checked QBAI tab carefully. No problem to populate with your summary. Let me know more details. Regards Lian
$20 USD v 40 dnech
4,9 (169 recenze)
7,2
7,2
Avatar uživatele
Dear client I can write the macro code for you which will solve the purpose. I understand the requirements completely and I ensure the job will be done accurately. I estimate time of completion to be 7-8 working hours. please contact me. Regards Roy
$20 USD v 40 dnech
4,9 (367 recenze)
7,0
7,0
Avatar uživatele
Hi there, thanks for the heads up, yes, I can import and update excel fields accordingly. Please reply, we can get started. Thank you.
$15 USD v 4 dnech
4,8 (251 recenze)
6,3
6,3
Avatar uživatele
Hi, I have experience in excel working, formulas, macros, pivot, ... please contact me so that we can have a discussion in detail
$20 USD v 40 dnech
4,6 (16 recenze)
5,9
5,9
Avatar uživatele
Hello, I am Luis and I will be glad to assist you with your project. I know about Excel and Visual Basic and I can do this project fot you. Please contact me by chat then we could discuss further detials! Luis Romero
$20 USD v 30 dnech
5,0 (135 recenze)
5,6
5,6
Avatar uživatele
Hi, nice to meet you. I am database expert in IT company. I am top in database field in my company. I have been working database expert for 8 years. My skill is Python, Mysql, Postgresql, Excel, deep mathematician knowledge. I can implement your project within short time. If you want me, please call me. Best Regards
$15 USD v 40 dnech
4,9 (43 recenze)
5,5
5,5
Avatar uživatele
Hello there, You can have these services for your project. -Great Communications -Creative designs -Clean Code by 7+ year experienced expert developer -Dedicated Project Manager -Dedicated Server Manager -Project Analysis and Reporting on time -Follow up after the project completed -Work on reviews by client To know more and further discussion please message me, we are also ready for an interview. Regards, Bharat
$21 USD v 40 dnech
4,9 (30 recenze)
5,4
5,4
Avatar uživatele
I can develop a script to analyse the data in import tab and fill the yearly tabs with their respective data along with replicating the formulas from QBAI2010 tab to all year's tab, and also prepare a summary on summary tab. Please find below a brief introduction of myself. I am postgraduate(MBA) in finance with more than 5 years of experience in financial modeling, MIS reporting, advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automated financial models for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$30 USD v 40 dnech
4,9 (41 recenze)
5,6
5,6
Avatar uživatele
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. 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
$20 USD v 40 dnech
4,8 (88 recenze)
5,7
5,7
Avatar uživatele
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$20 USD v 40 dnech
4,9 (38 recenze)
5,2
5,2
Avatar uživatele
$ 15 ONLY!!! In Just 2 Hours!! EXCEL VBA MACRO & FORMULA EXPERT <<< 100% satisfaction first, then payment>>>
$15 USD v 2 dnech
5,0 (95 recenze)
5,2
5,2
Avatar uživatele
Hi,sir. Thanks for taking your valuable time for reviewing my proposal.I'm a senior developer with over 10 years of experience. I think I can be a candidate for your project. If you can give me your project, I'll do my best to complete it in a short time. I am confident of your project - Build an Excel scrip And I have been very familiar with skills such as Excel, PHP, Visual Basic, Javascript, Software Architecture and so on.
$22 USD v 1 dni
4,1 (8 recenze)
5,5
5,5
Avatar uživatele
Hi Good Day! A serious freelancer here. I've done a lot of work like this one before. I can help you to complete this project with high quality. I really know how to do this. Please consided my bid. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank youl
$15 USD v 20 dnech
4,9 (41 recenze)
4,7
4,7
Avatar uživatele
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$20 USD v 40 dnech
4,7 (17 recenze)
4,6
4,6
Avatar uživatele
Hi, I have gone through the complete description and i am good at macros, Database and advanced excel with extensive experience of 5+ years which I would consider myself as the best approach for this project. let me if my skills and experience can come in handy for you.
$15 USD v 30 dnech
5,0 (3 recenze)
2,1
2,1

O klientovi

Pochází z UNITED STATES
Waldorf, United States
0,0
0
Ověřená platební metoda
Členem od říj 25, 2011

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.