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