Find Jobs
Hire Freelancers

Excel User Form

$10-30 CAD

Folyamatban
Kiadva ekkor: több mint 7 évvel ezelőtt

$10-30 CAD

Teljesítéskor fizetve
I'm looking for a user form in excel. It has to be launched from the sheet and record all captured data into another workbook. Refer to the attached for all the fields that are needed. Requirements: 1. All drop downs data selections are pulled from a sheet and you cannot be allowed to type your own 2. Hierarchical selection in the following structure Project Owner>Project Category> Project Sub-Category>Vendor. Example from the attached image: If Bob is selected as a project owner then populate only project categories for Bob to be selected. 3. All Fields are mandatory so provide error messages corresponding to the field when it's left empty 4. Don't allow duplicate entries by checking on Invoice # and Vendor as unique identifiers. Also provide warning message when duplicate is detected 5. Provide commentary lines above each code in vba
Projektazonosító: 12011132

A projektről

43 ajánlat
Távolról teljesíthető projekt
Aktiválva: 7 é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
43 freelancers are bidding on average $51 CAD for this job
Felhasználó avatár
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$34 CAD 1 napon belül
4,9 (374 értékelés)
8,1
8,1
Felhasználó avatár
Hello, I can do that for you pretty easily for a cheaper price. I am vba programmer excel expert and would be glad to start immediately
$88 CAD 1 napon belül
5,0 (203 értékelés)
8,2
8,2
Felhasználó avatár
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on skype as well: ashish260287 Thanks and Regards, Ashish Singhal PLEASE CHANGE THE ATTACHED FILE'S FORMAT TO XLSM BEFORE USING.
$25 CAD 1 napon belül
5,0 (204 értékelés)
7,8
7,8
Felhasználó avatár
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$90 CAD 3 napon belül
4,9 (269 értékelés)
7,6
7,6
Felhasználó avatár
Hi, I can do all kind of screen layout's (user forms), reports, and dynamic dashboards on excel by formulas, pivot tables, charts, and VBA. I am a specialist in financial reports, budget, costing reports, inventories, bill of materials together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports showing the relevant information in dynamic dashboard and graphs. Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services.
$55 CAD 1 napon belül
4,9 (91 értékelés)
7,2
7,2
Felhasználó avatár
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$40 CAD 1 napon belül
5,0 (225 értékelés)
7,0
7,0
Felhasználó avatár
i can do it for you quickly and exactly
$100 CAD 2 napon belül
4,9 (129 értékelés)
7,1
7,1
Felhasználó avatár
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
$100 CAD 3 napon belül
4,9 (282 értékelés)
7,1
7,1
Felhasználó avatár
Hello , I would like to work on your project. I have great experience using excel and macros / vba, userforms, dropdown lists. Provide please details and sample file in PM. Thank you. Regards
$70 CAD 3 napon belül
5,0 (138 értékelés)
6,6
6,6
Felhasználó avatár
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I will develop validation rules, error for empty values and duplicates, searching for specific records. I also write notes for the logic. I have excellent knowledge and experience of creating User Form and its elements button, combo, drop down, option buttons etc. in excel VBA. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra
$30 CAD 1 napon belül
4,8 (94 értékelés)
5,8
5,8
Felhasználó avatár
Recently done a dynamic drop down with 5 Subcategories, based on the first the next would be populated. Its based on Role and workstructure. Have good expertise in Excel automations. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc. - Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel - Pl. review my portfolio on recent projects. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions - extracting, modifiying mails in Inbox, retrieving calendar, tasks or scheduling.
$100 CAD 3 napon belül
4,7 (51 értékelés)
6,0
6,0
Felhasználó avatár
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$35 CAD 3 napon belül
4,9 (58 értékelés)
5,4
5,4
Felhasználó avatár
Hi Greetings! Please come over discussion and clarify about the type of data and format of the template. I will give my best to complete the project. I will be available on your time, so, communication is not a problem between us. I will be waiting for you. Regards Dibakar
$25 CAD 1 napon belül
4,8 (50 értékelés)
5,2
5,2
Felhasználó avatár
Hi! I can complete your project in one day. But your budget is too small for this kind of task. I\ll develop it for $50 CAD
$50 CAD 1 napon belül
5,0 (19 értékelés)
4,5
4,5
Felhasználó avatár
Hello, I have completed very similar projects. I have the structure, but I need to modify it to your needs. If you are interested please share the file. Best Regards
$60 CAD 1 napon belül
5,0 (21 értékelés)
4,4
4,4
Felhasználó avatár
Hi, I performed Projects like yours. I would like to provide you with a sample. Thanks!......................................................
$111 CAD 1 napon belül
4,6 (12 értékelés)
3,8
3,8
Felhasználó avatár
Hello. I can do this for you. I have a lot of experience in vb scripting. This is an easy job for me, I've done much more complicated scripts. If you want, I can show you samples, or I can give you a free demo for your project. I know I don't have any vb projects on freelancer.com, but you can see from my feedbacks that I'm a trusted person.
$30 CAD 5 napon belül
5,0 (4 értékelés)
3,2
3,2
Felhasználó avatár
I am Mechanical Engineer, proficient in Excel Macro, User form, 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 Proficient in Google Sheet Worked on Macro, VB, Pivot, User Form, Google Sheets 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.
$50 CAD 2 napon belül
3,9 (9 értékelés)
3,5
3,5
Felhasználó avatár
A proposal has not yet been provided
$30 CAD 1 napon belül
5,0 (5 értékelés)
2,7
2,7
Felhasználó avatár
Hello! Good Day! My name is Moshiur. I have read the job description and very much interested in the Project that you posted, so I'm applying for this job. I am an expert in those fields that you mentioned in the job description. I have already completed a lot of projects like this over the past 7 years. I have the ability to deliver accurate results in the deadline. So, I hope you will give me chance to work for this project. Respectfully, Moshiur
$20 CAD 1 napon belül
5,0 (1 értékelés)
1,3
1,3

Az ügyfélről

CANADA zászlója
Toronto, Canada
5,0
16
Fizetési mód hitelesítve
Tagság kezdete: aug. 20, 2008

Ü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.