Find Jobs
Hire Freelancers

Create excel spreadsheet pre- populated and free type to upload to a student management system -- 2

$30-300 AUD

In Progress
Posted about 8 years ago

$30-300 AUD

Paid on delivery
See attachments for further details We require all questions in the pre-poulated questionnaire to be VBA coded as per the screen shot at the bottom of the page and as per the following information [login to view URL] It is to be horizontal across excel spreadsheet 1 and have a maximum of 20 places for student names vertically. The information is to be saved in spreadsheet 1 and uploaded to our student management system. Spreadsheet 2 Names from spreadsheet 1 will pre-populate spreadsheet 2 vertically in order of how they were entered in spreadsheet 1 - All boxes from theory to scenarios will have a drop down box with a choice of S or NYS - Assessed as C or NYC column will have drop down box with a choice of C or NYC - Ignore black section of form
Project ID: 10034401

About the project

28 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$150 AUD in 3 days
4.9 (89 reviews)
6.4
6.4
28 freelancers are bidding on average $142 AUD for this job
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
$100 AUD in 3 days
4.9 (209 reviews)
6.3
6.3
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 AUD in 7 days
5.0 (87 reviews)
6.0
6.0
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$210 AUD in 3 days
4.9 (59 reviews)
5.5
5.5
User Avatar
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 and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$155 AUD in 3 days
4.5 (37 reviews)
5.5
5.5
User Avatar
I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification. Ready to start work immediately.
$100 AUD in 2 days
4.9 (33 reviews)
4.6
4.6
User Avatar
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details
$200 AUD in 5 days
5.0 (30 reviews)
4.1
4.1
User Avatar
Hi My name is Dan. I am an expert in excel and all advanced functionalities. I have designed several such use form for ease of data input and I can do this for you. I can create the spreadsheet 2 to feed data from spreadsheet 1 automatically. Please message me so that we can proceed further. Thanks ! Regards Dan
$222 AUD in 3 days
4.9 (10 reviews)
4.3
4.3
User Avatar
Hi, I'm a senior programmer in VB.Net/C#/VBA and VSTO. I would be happy to help you with your project. My only question is do we have some liberty about the formatting present in the spreadsheet 1? Based on my experience, it's not a good idea to store values in combo box, as you will have a user form to enter your data, do I am allowed to replace to checkbox by something that will be more future proof? My idea is to use a table (this allow you to insert/add/delete rows like a true database), the user form will simply insert row in this table. I can limit you to 20 rows but a design like this is not limited in any way, so I will let you decide about this restriction. If you still want the check box, I can save their values in a hidden column (this will not be apparent to your user), this way you kept the advantage of the table, and the look of you current spreadsheet 1. Also, if I understood correctly, the upload to your management environnement will be done manually on your side, so I did not add any milestone for this part. Let me know if you want to work with me, I'm not only good with Excel/VBA, I can also guide you about the best practice to use. For your information I'm available to work on my freelancer project from 18h30 to 21h30 EST each day. I'm working as a software architect (8h-17h EST) for a big accounting company and using freelancer only to challenge myself. It should not take me more then 1 day to deliver you the final result. Best regards, David
$240 AUD in 2 days
5.0 (2 reviews)
2.5
2.5
User Avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance calendar and calculator You can see the reviews of the same in my profile
$120 AUD in 3 days
5.0 (3 reviews)
2.6
2.6
User Avatar
Please see my reviews to know my experience. I can start immediately Hi Mr. Employer I can do this project in effective manner with 100 % accuracy report to fulfill your requirements. Pm me for more information and sample as well. Thank you for your opportunity to bid RoyalCalif
$77 AUD in 1 day
5.0 (3 reviews)
2.1
2.1
User Avatar
Dear Sir/ Madam I'm a professional VBA, VB and C# developer. I have 7+ years of experience in MS OFFICE and 4+ years of experience in VBA, VB and C# development. If you want your job done professionally and on time, I'm the person you're looking for. I am a very responsible, hard working with desire to bring my customers the best services. I am willing work with you immediately and delivery on time. My strongest skills: - Excel formula, report, dashboard template. - Ms office automation script includes excel, word, access. - Ms project automation, schedule task. - Ms office user form. - C# window form, window application. - parse xml, html, json. - SQLite, My SQL, SQL sever communication. - PDF template, parse pdf file. I can start working now. Hope you will give me this opportunity. I look forward to hearing from you. Thank you. Minh (Mr.) Skype: minh15.01.1991
$88 AUD in 3 days
3.6 (5 reviews)
3.0
3.0
User Avatar
Evidently you need a data entry screen. At the end it should transfer data in another sheet in subsequent rows. You want to skip few questions on conditional answers. You need macro to do the same. I have planned similar projects. I am proficient in Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
$155 AUD in 5 days
4.2 (3 reviews)
1.5
1.5
User Avatar
Hello,I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST
$155 AUD in 3 days
5.0 (1 review)
0.5
0.5
User Avatar
I believe i am the best candidate for this project because i have more than enough hands on experience in entering and processing data using Microsoft Excel/VBA. I also pay good attention to speed, details and accuracy when working with data
$40 AUD in 4 days
5.0 (1 review)
0.6
0.6
User Avatar
I work before at office and I usually do computer jobs and I can say that I will be the best since I already have experience of this kind of job that you offer.
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very familiar with this type of project, so I feel comfortable in addition to deliver excellent results
$72 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience of Data Entry and Web Research. I can do every kind of Data Entry with 100% accuracy. I am also proficient in MS Word, Excel , PowerPoint and Photoshop. I am quick learner and hard working. I believe that I will work very well for this job because I have a very good experience of these kind of jobs. I will do this job with 100% accuracy. Kindly consider my request for this job. I'll be looking forward to your kind response. Thanks Kind Regards, Usman
$100 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear employer, hereby summarized my capability & service offered: 1. 3 years experiences developing VBA excel macro automation project more than 100 projects in Intel company, covering global scope 2. Enable saving more than 10K hour savings in total throughout those projects 3. Able to cover wide range of VBA automation task 4. Able to delivery output within short time given 5. Setup numbers of controls, checking & desktop manual to ensure changes in user able to catch up easily
$35 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I think a few things make me a great fit for this position. Quality first every thing Best is our team work. I have the right combination of skills and experience for your job. I have big team and I can do the work and deliver exceptional results for your Data entry.
$150 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Floreat Forum, Australia
5.0
9
Payment method verified
Member since Feb 2, 2011

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.