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.

The functionality you describe is that of a database.

Office xp developer has a packager that creates a runtime database - eliminating the need for a full install of access.

As to necessary skills - to search thru client recs in either xl of access would require the same user skill. Make it user friendly enough you'll find access is the better tool for the job.

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