Excel VBA Developer
Worldwide
We are looking for an Excel VBA developer to build an internal IT support ticket tracking workbook. Deliverables A single Excel workbook (.xlsm) with four sheets: Clients – stores client information. IT Staff – stores IT staff information. Tickets – stores all tickets submitted through the UserForm. Dashboard – summarizes and analyzes ticket data. An Excel VBA UserForm to log new tickets that: Retrieves the Client and Assigned Staff from the Clients and IT Staff sheets. Saves each ticket to the Tickets sheet using a Submit button and includes a Cancel button to reset the form. Includes the following fields: Client, Contact, Category, Priority, Description, Assigned Staff, and Status. Auto-generated Ticket IDs. Dropdown lists for Status, Priority, and Category (lists will be provided). Dashboard with ticket counts by status, generated by one-click refresh button. Testing Include removable sample data to demonstrate all functionality. Requirements Strong Excel VBA experience (UserForms, macros, and formulas).
$100.00
Fixed-price- IntermediateExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Interviewing:0
- Invites sent:0
- Unanswered invites:0
About the client
- United States8:16 AM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by