Find Jobs
Hire Freelancers

Build an Excel scrip

$15-25 USD / hour

Lezárt
Kiadva ekkor: több mint 4 évvel ezelőtt

$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
Projektazonosító: 20939532

A projektről

32 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
32 szabadúszó adott átlagosan $20 USD/óra összegű árajánlatot erre a munkára
Felhasználó avatár
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 40 napon belül
4,9 (397 értékelés)
8,1
8,1
Felhasználó avatár
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 40 napon belül
4,9 (105 értékelés)
7,9
7,9
Felhasználó avatár
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 40 napon belül
4,9 (164 értékelés)
7,7
7,7
Felhasználó avatár
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 12 napon belül
5,0 (217 értékelés)
7,5
7,5
Felhasználó avatár
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 20 napon belül
4,8 (269 értékelés)
7,7
7,7
Felhasználó avatár
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 40 napon belül
4,9 (169 értékelés)
7,2
7,2
Felhasználó avatár
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 40 napon belül
4,9 (367 értékelés)
7,0
7,0
Felhasználó avatár
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 4 napon belül
4,8 (251 értékelés)
6,3
6,3
Felhasználó avatár
Hi, I have experience in excel working, formulas, macros, pivot, ... please contact me so that we can have a discussion in detail
$20 USD 40 napon belül
4,6 (16 értékelés)
5,9
5,9
Felhasználó avatár
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 30 napon belül
5,0 (135 értékelés)
5,6
5,6
Felhasználó avatár
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 40 napon belül
4,9 (43 értékelés)
5,5
5,5
Felhasználó avatár
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 40 napon belül
4,9 (30 értékelés)
5,4
5,4
Felhasználó avatár
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 40 napon belül
4,9 (41 értékelés)
5,6
5,6
Felhasználó avatár
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 40 napon belül
4,8 (88 értékelés)
5,7
5,7
Felhasználó avatár
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 40 napon belül
4,9 (38 értékelés)
5,2
5,2
Felhasználó avatár
$ 15 ONLY!!! In Just 2 Hours!! EXCEL VBA MACRO & FORMULA EXPERT <<< 100% satisfaction first, then payment>>>
$15 USD 2 napon belül
5,0 (95 értékelés)
5,2
5,2
Felhasználó avatár
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 1 napon belül
4,1 (8 értékelés)
5,5
5,5
Felhasználó avatár
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 20 napon belül
4,9 (41 értékelés)
4,7
4,7
Felhasználó avatár
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 40 napon belül
4,7 (17 értékelés)
4,6
4,6
Felhasználó avatár
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 30 napon belül
5,0 (3 értékelés)
2,1
2,1

Az ügyfélről

UNITED STATES zászlója
Waldorf, United States
0,0
0
Fizetési mód hitelesítve
Tagság kezdete: okt. 25, 2011

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.