Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Worksheet Form / Database reporting
I have a worksheet form which I want to use to create
multiple records for client details. I then want this to automatically produce the raw data into a spreadsheet for manipulation. I have used the worksheet form examples and templates for automatically producing into a database and it hasn't worked. So, two parts to my question: 1. Can I create a form which user/s can scroll through to view individual client records; and 2. Can this data be transferred into a separate spreadsheet source. I could do this in MSAccess but the users won't have this program or skills etc. |
#2
|
|||
|
|||
Maybe you could use excel's built in Data|Form.
Or if that isn't sufficient, John Walkenbach's enhanced data form: http://j-walk.com/ss/dataform/index.htm And Debra Dalgleish has some get started with userforms notes at: http://www.contextures.com/xlUserForm01.html And if you write the code yourself, you could have the form populate any worksheet you want. Rose wrote: I have a worksheet form which I want to use to create multiple records for client details. I then want this to automatically produce the raw data into a spreadsheet for manipulation. I have used the worksheet form examples and templates for automatically producing into a database and it hasn't worked. So, two parts to my question: 1. Can I create a form which user/s can scroll through to view individual client records; and 2. Can this data be transferred into a separate spreadsheet source. I could do this in MSAccess but the users won't have this program or skills etc. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
PLEASE HELP!? Creating a simple database with excel, minor setback | Excel Worksheet Functions |