I want to create a record maker in Excel that will continuously add rows with new data (Ex: Name, Address, Phone Number). When the user clicks submit, it would add the row to the previously entered data, and save the full database as a csv. Part 2 of this would be able to click on a previously created record and when selected bring up all the entered data so the user can make quick edits to it. Has anyone done anything like this before?
What you appear to be describing is a 'pseudo' database created with Excel.
This can be achieve simply by creating a UserForm as your interface and a 'structured table' to store/edit your data.
An example is attached that can easily be adapted for your needs.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
This is exactly what I was looking for. Great template...thank you!
thanks for the update and added rep point - glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks