Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need your help Excel Worksheet/Form
I have created a form on worksheet 1....I want to enter the data on worksheet
2 to automatically populate on the form in worksheet 1... but keep a running tally of the data in worksheet 2 which is the raw material..... example: in worksheet 2 column a1, would be the customer first name, column a2 would the customer phone number, column a3 would be the customer address, column a4 would be the customer city, state, zip..... as i enter the raw data from worksheet 2 to automatically populate into worksheet 1 (which I did - just fine) but now my problem is keeping the data in the ROWS column example: row 1 - customer name, customer phone, customer address, customer city state zip (across the top rows) to display in a spreadsheet format.... so that I can see that I have completed this form for this customer... thank you... Please let me know if you can assist me... I know that the form (worksheet 1) will change as the data from (worksheet 2) is enter, and that is fine.... i just want the data stay in the worksheet 2 as the spreadsheet.... so in the future, I can go to row 115 and see the data entered... I know someone knows how this is completed.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need your help Excel Worksheet/Form
OK here is how I have done it the past using Excel 2003.
First you are really doing it backwards and also having an extra worksheet for nothing. First dont start with A1, drop down to row 4 or 5, there are other reasons why you should do this in practice that the explanation isnt needed here to do what you want. Worksheet 1 A4 = First Name B4 = Last Name C4 = Address D4 = City E4 = State F4 = Zip G4 = Phone Highlight rows A4 thru G5. Go to main menu click on Data and then Forms. You may get a pop message box, click OK. You will have a blank form showing your headers as above. Enter you data in the form as you laid it out, when finished click - New. Information will fill in the empty row with your data. A new blank form will appear. Just keep going entering your data, each row will fill in. Depending on the size of your data that you want to enter, number of columns, drop down enough rows so that your form fits in the upper left corner of your worksheet and your data below it. Then you just work your form and the data fills in down the line. To find a customer or name as you have it, highlight Name on the worksheet, open your form, click on the command button Criteria and enter the phone number, for an example, since as per your example it is the only thing which would or may not be a duplication, click on Find Next and the name and information will appear in your form. If every entry youre going to make is within the same area code no need to enter it, if there is a possible of having another area code use it as 2034567890. It will save a lot of time in looking up the phone number, that is key strokes instead of (203) 456-7890. -- Mr C "july" wrote: I have created a form on worksheet 1....I want to enter the data on worksheet 2 to automatically populate on the form in worksheet 1... but keep a running tally of the data in worksheet 2 which is the raw material..... example: in worksheet 2 column a1, would be the customer first name, column a2 would the customer phone number, column a3 would be the customer address, column a4 would be the customer city, state, zip..... as i enter the raw data from worksheet 2 to automatically populate into worksheet 1 (which I did - just fine) but now my problem is keeping the data in the ROWS column example: row 1 - customer name, customer phone, customer address, customer city state zip (across the top rows) to display in a spreadsheet format.... so that I can see that I have completed this form for this customer... thank you... Please let me know if you can assist me... I know that the form (worksheet 1) will change as the data from (worksheet 2) is enter, and that is fine.... i just want the data stay in the worksheet 2 as the spreadsheet.... so in the future, I can go to row 115 and see the data entered... I know someone knows how this is completed.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print an excel worksheet that contains a form. | Excel Discussion (Misc queries) | |||
How do I save worksheet form data into a table in Excel 2003? | Excel Discussion (Misc queries) | |||
How to..use worksheet form and save data to an Excel list | Excel Discussion (Misc queries) | |||
How do I convert an excel worksheet to a fill in form? | Excel Discussion (Misc queries) | |||
Excel Worksheet Form / Database reporting | Excel Discussion (Misc queries) |