Need your help Excel Worksheet/Form

[july]

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..

 

[Mr C]

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 don’t start with A1, drop down to row 4 or 5, there are other reasons
why you should do this in practice that the explanation isn’t 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 you’re 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.