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.

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