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 |