Data Entry Tool

Raggnar

New Member
Joined
Feb 1, 2019
Messages
1
[h=1]Hello,<o:p></o:p>
I am an Excel novice, but I need to complete this little tool ASAP, I’ve donesome research but realized very quickly I was either getting wrong or halfanswers. I’m hoping that the folks here can read the description of whatI want and lay out what I will need to complete it, if I can just get the nameof the avenues I should pursue it would help me greatly. I’m not afraidto put the work in to learn, I would just like to limit the scope to just whatI need to finish this project if I can. I am willing to branch out intoany area required to finish this tool, just lay out what you think the bestpath would be, I will take it from there. Thank you in advance for anyhelp given, it is much appreciated. <o:p></o:p>
I have a large amount of data that needs to be entered manually, the tool Ineed seems simple, but I barely have a rudimentary understanding of Excel sonot even knowing terms has made it difficult to figure out on my own. Ineed 5 entry boxes (maybe more maybe less) with this functionality. Theuser will select the box, once a character is entered into the field anautocomplete feature will go into effect, as the user adds characters the entrybox should narrow the autocomplete finding all appropriate previous entries. <o:p></o:p>
<o:p></o:p>
Example:<o:p></o:p>
E_ Ex_ Exa_<o:p></o:p>
Empathy Example Example<o:p></o:p>
Episode Examine Examine<o:p></o:p>
Example Extra<o:p></o:p>
Examine<o:p></o:p>
Extra<o:p></o:p>
<o:p></o:p>
Once each entry boxis complete to the user’s satisfaction, they hit a SUBMIT button which createsa database record. I also need to be able to sort the databaseindividually by each column. <o:p></o:p>
Well, that’s what I need, now that I’ve written it out it seems oh so simple,but I have been stumped at every turn trying to get exactly what I need. Please, no matter how complicated the answer feel free to let it fly. Iwill abandon Excel if it’s the only way to complete this task. Again,thank you to anyone who took the time to read or respond to thisquestion.

<o:p></o:p>
*** For the time being this tool will stay in Excel but eventually I wouldlike to use it in a web format so the ability to be converted to thisapplication would be excellent.<o:p></o:p>
[/h]
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
It sounds like you have described an Excel worksheet.

Put your headers in the first row of a worksheet.
As you type, Excel's autocomplete will look at the other entries in that column and offer suggestions.

As for filtering, AutoFilter is the built in feature of Excel that you want.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top