Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING NEW NUMBERS TO EXISTING WORKSHEET
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 -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=498360 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sometimes cannot see existing worksheet when i open it without full screen toggled on | Excel Discussion (Misc queries) | |||
How do I conditionally build worksheet from existing worksheet? | Excel Discussion (Misc queries) | |||
Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
format existing numbers in excel? | Excel Discussion (Misc queries) |