ADDING NEW NUMBERS TO EXISTING WORKSHEET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KwithanE - 05 Jan 2006 17:22 GMT

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?

Reply to this Message

keithl816 - 08 Jan 2006 16:42 GMT

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.

Code:
--------------------

Sheets("Sheet1").ShowDataForm

--------------------

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

Signature

keithl816

Reply to this Message