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. |
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 |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com