Find Jobs
Hire Freelancers

Excel VBA macro - logging survey responses

$15-25 USD / hour

Imekamilika
Imechapishwa over 6 years ago

$15-25 USD / hour

We have an Excel template that has the structure for a survey build into two tabs. Dropdown selections are already available via data validation. We want someone to make this template function more like an actual survey, where, once someone completes the responses, they click a "submit response" button and the data they've completed are sent and stored in a separate table (preferably one that is in a separate Excel file stored in a remote location), and the form is cleared so the next person can work on it; we anticipate this will involve the use of macros. There are currently 155 questions (63 in one tab, 92 in the other), each with 2-5 answer choices and a comments box next to each one. We also want to move the scoring of each question to the separate database(s). We imagine this project will involve creating macros or other code to automate the submission of responses.
Kitambulisho cha mradi: 15956015

Kuhusu mradi

28 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
$15 USD ndani ya siku 3
4.9 (31 hakiki)
4.9
4.9
28 wafanyakazi huru wana zabuni kwa wastani $21 USD/saa kwa kazi hii
Picha ya Mtumiaji
Hello Sir, Thank you for this opportunity. My name is Jay and 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 niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$21 USD ndani ya siku 20
5.0 (745 hakiki)
8.5
8.5
Picha ya Mtumiaji
HI, I am good at Excel and vba. i have reviewed the details. I have worked on similar type of project in the past. That has similar functionalities and score will be based on the answers selected. Clearing the data and placing the fresh answers are also applied. Please share me the excel file provided to reivew and discuss further in the chat. -Chandra
$20 USD ndani ya siku 30
5.0 (882 hakiki)
8.0
8.0
Picha ya Mtumiaji
Greeting, I have understood your Excel VBA macro - logging survey responses task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Excel, Visual Basic, Visual Basic for Apps
$22 USD ndani ya siku 40
4.9 (340 hakiki)
8.0
8.0
Picha ya Mtumiaji
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$25 USD ndani ya siku 20
4.9 (335 hakiki)
7.3
7.3
Picha ya Mtumiaji
Hello Sr., how are you ? Jorge is my name and I have experience doing programs using VBA Code (with Excel for example). Several solutions I've created merging VBA Code (language used to create Macros) and Excel for different customers. You can visit my Portfolio to know my last jobs regarding these skills, the reviews received from clients and as you can see, a higher percentage of jobs completed. I'm interested to help you on this particular project. What I prefer is to discuss with you more in detail all your terms and I'll give you a better proposal. No more Sr.; contact me if you'd like it and I will do the best, Regards. Jorge. P.S.: I will not accept any award before to discuss with you all the details needed.
$25 USD ndani ya siku 20
5.0 (181 hakiki)
7.2
7.2
Picha ya Mtumiaji
Hello. My name's Paris and I'm an experienced Excel VBA developer. Over the last 10 years, I had the chance to work on some very complex and demanding projects involving hundreds of line codes. Your project seems to be rather interesting and it indeed requires code to implement all you describe in your brief. I'd like to work with you. If you need to ask me something don't hesitate to do so. I'll have an answer for you the quickest possible. I'm looking forward to working with you. Paris
$20 USD ndani ya siku 40
4.9 (236 hakiki)
7.5
7.5
Picha ya Mtumiaji
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. Best regards
$20 USD ndani ya siku 20
4.9 (239 hakiki)
6.9
6.9
Picha ya Mtumiaji
Hi there, I can write the VBA script quickly. I'm an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman
$24 USD ndani ya siku 15
4.9 (178 hakiki)
6.6
6.6
Picha ya Mtumiaji
Hi, I am Nallakumar. I have more than 11 years of experience in VBA and Office Automation. We can save the master data Excel (or preferable MS Access DB) in remote location and hard code the path in the Survey Excel and achieve the required functionality. I can complete code and testing in quoted 16 hours. Thanks, Nalla
$21 USD ndani ya siku 16
5.0 (17 hakiki)
6.2
6.2
Picha ya Mtumiaji
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel macro enabled project in Excel or via Ms Access software very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$22 USD ndani ya siku 40
4.7 (33 hakiki)
5.8
5.8
Picha ya Mtumiaji
Hi, I wouldn't recommend you usage of macros and storing data remotely to another Excel file. Why? - Because it is easy to unlock macros so one could easily find out path to remote Excel file and access it, modify or delete... Would you consider creating light survey website instead of Excel and have administrative access to the website to either review data or export it to Excel? With this budget that is doable. Therefore I would like to offer: - create a survey website - create link which can be sent to users to fill in survey data (by the link itself you would know which user completed survey and which did not) - administrative access to the survey site to manage data: review, export etc. It would be more professional comparing to Excel file... Just thinking ... Please let me know if you find this interesting for further discussion. Thank you.
$33 USD ndani ya siku 10
5.0 (14 hakiki)
5.0
5.0
Picha ya Mtumiaji
Hi, Kindly review my profile to know more about my skills and experience required for this project. Regards Awaisjehangir
$20 USD ndani ya siku 20
4.6 (37 hakiki)
5.3
5.3
Picha ya Mtumiaji
My name is Deepak. I work as a full-time MS Access & Excel Programmer. I have spent the past 4+ years doing full automation, building custom applications, number crunching, and database management for MS Office businesses, and I am keen to continue developing my career in the field of data analysis, Access Database, Excel and VBA programming.   My expertise relies on: 1.         Solid knowledge of table/query design, form/report design, and automation utilizing VB modules. 2.         Expertise in debugging developed VBA codes and fixing them. 3.         Having Experience in Support Access and Excel application with SQL Server backend  4.         Experience in Identifying and understanding the requirements of the clients with respect to the database administration system that needs to be developed. 5.         Well versed with database concept and experience in using SQL statements for data validations.  6.         Have experience in developing Access databases and applications using VBA for data transformation and validation projects. 7.         Experience in design, automation, and solution development of various applications, including integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens with professional UI interfaces. 8.         Developing data models and designing the database architecture as per the given instructions and modifying them to accommodate the system requirements. Installing several security features and granting access levels as per the user privileges set by the client to ensure maximum protection of the database system and avoiding theft of valuable data. 9.         Collecting data from various sources like QuickBook, Excel, MySQL, SQL, Azure and Manipulating, cleansing & processing data using Excel, Access, Macro, VBA, and SQL. 10.       Creating attractive and dynamic Reports in MS Access. 11.       Implementing Google Charts, Map into MS Access Forms, Reports (both offline and online).
$15 USD ndani ya siku 5
4.9 (18 hakiki)
4.9
4.9
Picha ya Mtumiaji
Good day, I am a Sydney based, English speaking university graduate with 17 years experience using excel to solve complex business problems. My key strengths include: Financial analysis and modelling, Business Case Evaluation, Process Automation, API and Real Time Data Exchange, Business Intelligence, Web Scraping, Data Extraction, Data Aggregation, Master Data Management, VBA and Macro Troubleshooting / Development, Advanced Reporting and Dashboarding. Over and above my Excel knowledge and skills, I have 12 years corporate business experience and have developed strong commercial acumen around value delivery and customer service. I work quickly, accurately and professionally and am available immediately. Warm Regards Wesley Jeftha
$24 USD ndani ya siku 40
5.0 (12 hakiki)
4.9
4.9
Picha ya Mtumiaji
I have experience making clean and efficient macros for automation of tasks. I can also make form to be sent to different file and clear form for next entry.
$15 USD ndani ya siku 40
5.0 (4 hakiki)
3.4
3.4
Picha ya Mtumiaji
I offer you high dedication, quality and speed. I am Software Engineer; +10 years in Excel a (Macros, VBA, Functions, Pivot tables) My offer is low since I need to create my reputation. My country has a non-dollar economy, this payment is representative for me.
$15 USD ndani ya siku 40
5.0 (5 hakiki)
3.6
3.6
Picha ya Mtumiaji
A proposal has not yet been provided
$16 USD ndani ya siku 40
5.0 (6 hakiki)
2.9
2.9
Picha ya Mtumiaji
Hi, I've worked for twenty years with MS Excel from version 5.0 onward and created many mini applications using VBA to power them. I would have a question on the connectivity to a remote excel document. Is it a shared drive somewhere so you know it will always be able to connect. Many regards
$22 USD ndani ya siku 40
5.0 (6 hakiki)
3.1
3.1
Picha ya Mtumiaji
Hello, I have read your project details. This job can be done using excel, but It would be much better as a simple desktop application, I can do that Contact me over chat
$16 USD ndani ya siku 10
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Let`s finnish this together. I`m prepared to provide the solution for this survey. Let me know if I can proceed.
$22 USD ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
Washington, United States
5.0
2
Njia ya malipo imethibitishwa
Mwanachama tangu Des 27, 2017

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.