Data Entry Forms

S

Sutek

New Member
Joined
Jan 27, 2015
Messages
4
Hello all,
this is fairly basic stuff, so please be patient with me, as i am really new to this and keen to learn.
I have a spreadsheet, worksheet or whatever its best title is, which has a list of customers and details for each. I can enter data onto this sheet easily, however, I want to make it idiot proof (yep my business partner knows less about spreadsheets than i do). I want to be able to enter all the data, for a particular customer and their job, from a form. I also want this form to be permanently visible, in fact it would be better if the form was the only thing my partner could see (to remove the temptation to play with the spreadsheet).
So my questions are these:
How do i create a permanent form to enter the data? and can i get it to automatically show up, as at least the first screen?
I have more than 32 columns of data (not all of which, has to be populated from a form) Excel keeps telling me i have to many fields for a form.
Can i split the data up and have it all reference back to each other? e.g. have several forms that populate one sheet with different sets of data. Such as, one form for customer details and another for their jobs and yet another for their remaining jobs.
I've included the data as it appears in my spreadsheet.
Any advice on my best course of action would be appreciated
thanking you all in advance
Cheers
Cal[TABLE="width: 5324"]
<colgroup><col><col><col span="3"><col><col><col><col><col><col><col span="3"><col><col><col><col><col><col span="3"><col><col span="3"><col><col><col><col><col><col><col><col><col><col span="3"><col><col span="3"><col><col><col><col><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]REF[/TD]
[TD]Date[/TD]
[TD]First Name[/TD]
[TD]Surname[/TD]
[TD]Title[/TD]
[TD]Street Address[/TD]
[TD]Suburb[/TD]
[TD]State[/TD]
[TD]Postcode[/TD]
[TD]Job Description[/TD]
[TD]Description 1[/TD]
[TD]Quantity 1[/TD]
[TD]Unit Price 1[/TD]
[TD]Cost 1 [/TD]
[TD]Description 2[/TD]
[TD]Quantity 2[/TD]
[TD]Unit Price 2[/TD]
[TD]Cost 2[/TD]
[TD]Description 3[/TD]
[TD]Quantity 3[/TD]
[TD]Unit Price 3[/TD]
[TD]Cost 3[/TD]
[TD]Description 4[/TD]
[TD]Quantity 4[/TD]
[TD]Unit Price 4[/TD]
[TD]Cost 4 [/TD]
[TD]Description 5[/TD]
[TD]Quantity 5[/TD]
[TD]Unit Price 5[/TD]
[TD]Cost 5 [/TD]
[TD]Description 6[/TD]
[TD]Quantity 6[/TD]
[TD]Unit Price 6[/TD]
[TD]Cost 6[/TD]
[TD]Description 7[/TD]
[TD]Quantity 7[/TD]
[TD]Unit Price 7[/TD]
[TD]Cost 7[/TD]
[TD]Description 8[/TD]
[TD]Quantity 8[/TD]
[TD]Unit Price 8[/TD]
[TD]Cost 8[/TD]
[TD]Description 9[/TD]
[TD]Quantity 9[/TD]
[TD]Unit Price 9[/TD]
[TD]Cost 9[/TD]
[TD]Description 10[/TD]
[TD]Quantity 10[/TD]
[TD]Unit Price 10[/TD]
[TD]Cost 10 [/TD]
[TD]Subtotal[/TD]
[TD]GST[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]THOGE[/TD]
[TD="align: right"]16-January-2015[/TD]
[TD]Geoffrey[/TD]
[TD]Burns[/TD]
[TD]Mr[/TD]
[TD]blah[/TD]
[TD]Wavel Heights[/TD]
[TD]Qld[/TD]
[TD="align: right"]4012[/TD]
[TD]Storm Damage Repairs[/TD]
[TD]Repair of broken leadlight panes in four(4) leadlight panels and one(1) door leadlight[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Site Preperation[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]HOOLJ[/TD]
[TD="align: right"]21-January-2015[/TD]
[TD]LJ[/TD]
[TD]HOOKER[/TD]
[TD] [/TD]
[TD]blah[/TD]
[TD]Wooloowin[/TD]
[TD]Qld[/TD]
[TD="align: right"]4030[/TD]
[TD]Storm Damage Repairs[/TD]
[TD]Relead of damaged leadlight panel, including replacing broken panes. Damage too extensive for onsite repair[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Site preparation and removal of leadlight[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]$[/TD]
[TD]Installation[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Lead Handling[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]GRILY[/TD]
[TD="align: right"]21-January-2015[/TD]
[TD]Lyn[/TD]
[TD]Baker[/TD]
[TD]Ms[/TD]
[TD]blah[/TD]
[TD]Red Hill[/TD]
[TD]Qld[/TD]
[TD="align: right"]4059[/TD]
[TD]Storm Damage Repairs[/TD]
[TD]Releadl centre leadlight panel due to extensive storm damage[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Relead RHS leadlight panel due to extensive storm damage[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]$[/TD]
[TD]Clean and Polish LHS leadlight panel [/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Site preparation and leadlight removal[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Installation of all leadlights[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Lead Handling[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Cost of Scaffolding to remove leadlights[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]DESEL[/TD]
[TD="align: right"]16-January-2015[/TD]
[TD]Elizabeth[/TD]
[TD]Jones[/TD]
[TD]Ms[/TD]
[TD]blah[/TD]
[TD]South Brisbane[/TD]
[TD]Qld[/TD]
[TD="align: right"]4101[/TD]
[TD]Storm Damage Repairs[/TD]
[TD]Site preparation and removal of leadlight[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]relead damaged leadlight[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]$[/TD]
[TD]rebuild damaged areas on leadlight[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$[/TD]
[TD]Installation[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Lead Handling Fee[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]MATSA[/TD]
[TD="align: right"]27-January-2015[/TD]
[TD]Sally[/TD]
[TD]Smith[/TD]
[TD]Ms[/TD]
[TD]blah[/TD]
[TD]Highgate Hill[/TD]
[TD]Qld[/TD]
[TD="align: right"]4101[/TD]
[TD]Storm Damage Repairs[/TD]
[TD]Site preparation and removal of leadlight[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Relead damagedmain leadlight door panel[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]$[/TD]
[TD]Relead damaged secondary leadlight panels[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Installation [/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Lead Handling Fee[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]MATSA[/TD]
[TD="align: right"]27-January-2015[/TD]
[TD]Sally[/TD]
[TD]Smith[/TD]
[TD]Ms[/TD]
[TD]blah[/TD]
[TD]Highgate Hill[/TD]
[TD]Qld[/TD]
[TD="align: right"]4101[/TD]
[TD]Storm Damage Repairs[/TD]
[TD]Onsite repairs of broken leadlight panes[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD]Site Preperation[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$0[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
Also just a note, it is very basic stuff but something like this would be easier for you to read a guide and "do it yourself" with own naming conventions as opposed to someone "doing it all for you", that way if something goes wrong for a userform like that it'll be easier for you to have an idea what happened.

Give updates how you're getting on, and let me know. If you're really stuck I can make the userform for you and code it up.
 
Upvote 0
Thanks for the help mate. I had a look at the link and its spot on what i was looking for. I'll work through the tutorials and modify them as needed. I was looking to do this all myself, for control, as well as getting familiar with all this.
 
Upvote 0
No problems man, that tutorial will set you up nicely, and as its all handmade you can make it look at pretty as you like :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Updating data in cell, run the macro again and it should not happen.
2 3 4
Replies
34
Views
1K
mumps
mumps
L
  • Question Question
MACROS WORK WELL, BUT WHEN I DELETE THE DATA TO LEAVE THE FILE WITHOUT INFORMATION, MACROS DON'T WORK
Replies
1
Views
207
leobrice
L
F
  • Solved
LET Formula Enhancement
Replies
2
Views
266
Fonzie
F
M
  • Question Question
Auto adjust row heights based on specific column
Replies
1
Views
405
XLfriend777
XLfriend777
C
  • Question Question
Total Specific Sections in Auto-filled Spreadsheet
Replies
3
Views
292
Cubist
Cubist

Forum statistics

Threads
1,223,911
Messages
6,175,322
Members
452,635
Latest member
laura12345

Share this page

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