Σε Εξέλιξη

Excel User Form

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

Δεξιότητες: Excel, Visual Basic

Δείτε περισσότερα: joomla upload form user, form filling excel macro, php shipping form user, php form data excel, html form post excel, multi user excel programs

Σχετικά με τον Εργοδότη:
( 16 αξιολογήσεις ) Toronto, Canada

ID Εργασίας: #12011132

Ανατέθηκε στον/στην:

nwss1986

Hi.i can start right now and can deliver you in a couple of hours. if interested, plz send me the excel file, if any.Thanks!!

$19 CAD σε 0 μέρες
(19 Αξιολογήσεις)
3.6

47 freelancers κάνουν προσφορές με μέσο όρο $52 γι' αυτή τη δουλειά

$150 CAD σε 1 μέρα
(249 Αξιολογήσεις)
7.6
elqueabandona

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 rega Περισσότερα

$100 CAD σε 3 μέρες
(153 Αξιολογήσεις)
6.5
Webxpert4u

Hello, I am ready to create excel user form. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsoft Excel Macros Περισσότερα

$136 CAD σε 2 μέρες
(106 Αξιολογήσεις)
6.7
paris2785

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 y Περισσότερα

$90 CAD σε 3 μέρες
(100 Αξιολογήσεις)
6.1
zebracaro

i can do it for you quickly and exactly

$100 CAD σε 2 μέρες
(79 Αξιολογήσεις)
5.6
$66 CAD σε 2 μέρες
(54 Αξιολογήσεις)
5.4
schoudhary1553

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 ex Περισσότερα

$34 CAD σε 1 μέρα
(66 Αξιολογήσεις)
5.2
nagyzoltan68

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 μέρες
(64 Αξιολογήσεις)
5.1
abhinovpankaj

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 vari Περισσότερα

$35 CAD σε 3 μέρες
(37 Αξιολογήσεις)
5.1
satishtl

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 automa Περισσότερα

$100 CAD σε 3 μέρες
(27 Αξιολογήσεις)
4.6
vsprybhanu

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 writ Περισσότερα

$30 CAD σε 1 μέρα
(42 Αξιολογήσεις)
4.8
ksriniravi

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 Reporti Περισσότερα

$40 CAD σε 1 μέρα
(33 Αξιολογήσεις)
4.7
serdaryalcin

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 μέρα
(19 Αξιολογήσεις)
4.2
$166 CAD σε 3 μέρες
(5 Αξιολογήσεις)
3.8
jnekam

Hi, I performed Projects like yours. I would like to provide you with a sample. Thanks!......................................................

$111 CAD σε 1 μέρα
(12 Αξιολογήσεις)
3.8
$25 CAD σε 1 μέρα
(11 Αξιολογήσεις)
3.7
$25 CAD σε 1 μέρα
(10 Αξιολογήσεις)
3.6
LuchianTeodor

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 Περισσότερα

$30 CAD σε 5 μέρες
(4 Αξιολογήσεις)
3.2
DLTechnologies

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 p Περισσότερα

$25 CAD σε 1 μέρα
(18 Αξιολογήσεις)
3.3
$70 CAD σε 2 μέρες
(14 Αξιολογήσεις)
3.5