adding new numbers to existing worksheet

I had a job once in Data Processing where I would take a paper form and input
the data in into a computer program then push "enter" and it would add that
data to pre-existing data that had previously been entered. Understand? I
have a forms that I need to enter into Excell so that when I put the numbers
in it will automatically add them to the previous forms. Plus when I push
"enter" It will give me a new page with all the data on it just no numbers.
Does this make sense? If so, can it be done?

Hi KwithanE,

You could use a data form to do what you are asking.

Click Cell A1, assuming that is your header row, then in the windows menu click Data/Forms. Should give you a box to input your data.

If you are wanting to creat a command button to prompt a data form to appear on the same or different page you can click on View/Toolbars/Control Toolbox.

Click on the command button icon and place it on the worksheet you want the button located on, Right click that button and select view code and insert this.

Please Login or Register  to view this content.

Change sheet1 to the name of the sheet you have the data on.

If the new page is just for viewing, you can just reference the cells you want to see. =sheet2!a1, =sheet2!c1, =sheet2!d1, etc....... skip the columns you do not want to view.

Another option would be to create your own userform.

Tools/Macro/Visual Basic Editor

This you will need to know code for.

Larry