| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I append data to an Excel workbook using a template?
I have created a data entry template in Excel, but don't know how to save it
and then add additional entries to the saved workbook. I don't have Access so I can't use that. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I append data to an Excel workbook using a template?
I'm assuming you've already tried the DataForm option from your menu and found it lacking what you need. If that is the case and
you want a form for data entry then you will have to use VBA and build a form. There are probably add-ins available that will do this for you. Also, if you want a simpler solution that does not require a form, you can set up a data input area on the spreadsheet but will still need VBA to deliver the input to new cells elsewhere on the WS. HTH -- RMC,CPA "Statman" wrote in message ... I have created a data entry template in Excel, but don't know how to save it and then add additional entries to the saved workbook. I don't have Access so I can't use that. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I append data to an Excel workbook using a template?
Thanks for the info. Yes, DataForm wasn't robust enough for my needs. Looks
like VB will have to be the answer. I suppose I'll need to read up on that. Once again, thanks for your reply. Mike "R. Choate" wrote: I'm assuming you've already tried the DataForm option from your menu and found it lacking what you need. If that is the case and you want a form for data entry then you will have to use VBA and build a form. There are probably add-ins available that will do this for you. Also, if you want a simpler solution that does not require a form, you can set up a data input area on the spreadsheet but will still need VBA to deliver the input to new cells elsewhere on the WS. HTH -- RMC,CPA "Statman" wrote in message ... I have created a data entry template in Excel, but don't know how to save it and then add additional entries to the saved workbook. I don't have Access so I can't use that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy excel workbook to new workbook without data | Excel Worksheet Functions | |||
| How can I look up data in a different workbook in an excel spread. | Excel Worksheet Functions | |||
| selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
Linear Mode
