| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I export data from an Excel form into an external Excel d.
I'm trying to create a form/template that users can use to enter data. I then
want this data compiled into a master Excel database that can then be analyzed. Any help/guidance would be really appreciated. |
|
#2
|
|||
|
|||
|
Take a look at Data|Form (built into excel).
If that doesn't fit your needs, look at John Walkenbach's enhanced data form: http://j-walk.com/ss/dataform/index.htm And if you want to see a small example, visit Debra Dalgleish's site: http://www.contextures.com/xlUserForm01.html vonda wrote: I'm trying to create a form/template that users can use to enter data. I then want this data compiled into a master Excel database that can then be analyzed. Any help/guidance would be really appreciated. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| Excel merge or data form (for invoice)..help!! | Excel Worksheet Functions | |||
| How can I export Excel data to Quicken? | Excel Discussion (Misc queries) | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
