Pointer please
 

I wish to create a data entry interface so a typist can enter a few lines of
text into a preformatted 'form' on seperate rows..
There could be say one or up to 25 of these seperate 'forms' to be filled in
at any one session.
Then she should save the file, and next day if there are more entries
(forms) to be added to the file, it is opened and more 'forms' created and
filled in.
I need a pointer as to whether this is a suitable application for Excel, and
ideally how it could have a box where the user selects how many blank
'forms' would be created for filling.
I think I can handle the subsequent accessing of the data from the Excel
file once a week and processing it.
Any help as to whether I am thinking along the right lines would be
appreciated.
Or where I should look for more info.

Brian Tozer

Hi Brian

"Data" is often about "input in a suitable format, store in another suitable
format and retrieve in any format needed". So don't save 25 identical forms
just because you need 25 sets of similar information.

It's very suitable for Excel. I'd use a Userform for entry, not a worksheet,
and save the raw data in a worksheet; 1 row only per record. See
http://www.contextures.com/xlUserForm01.html

HTH. Best wishes Harald

"KiwiBrian" skrev i melding
...
I wish to create a data entry interface so a typist can enter a few lines
of
text into a preformatted 'form' on seperate rows..
There could be say one or up to 25 of these seperate 'forms' to be filled
in
at any one session.
Then she should save the file, and next day if there are more entries
(forms) to be added to the file, it is opened and more 'forms' created and
filled in.
I need a pointer as to whether this is a suitable application for Excel,
and
ideally how it could have a box where the user selects how many blank
'forms' would be created for filling.
I think I can handle the subsequent accessing of the data from the Excel
file once a week and processing it.
Any help as to whether I am thinking along the right lines would be
appreciated.
Or where I should look for more info.

Brian Tozer

Thanks Harald, exactly the pointer that I needed at this stage.
Brian

"Harald Staff" wrote in message
...
Hi Brian

"Data" is often about "input in a suitable format, store in another
suitable
format and retrieve in any format needed". So don't save 25 identical
forms
just because you need 25 sets of similar information.

It's very suitable for Excel. I'd use a Userform for entry, not a
worksheet,
and save the raw data in a worksheet; 1 row only per record. See
http://www.contextures.com/xlUserForm01.html

HTH. Best wishes Harald

You may want to get some tips from the way John Walkenbach did his enhanced
data|form. You can find it at:
http://j-walk.com/ss/dataform/index.htm

(and the code is available for a minor fee ($20 USA), if you want to modify it.)

KiwiBrian wrote:

Thanks Harald, exactly the pointer that I needed at this stage.
Brian

"Harald Staff" wrote in message
...
Hi Brian

"Data" is often about "input in a suitable format, store in another
suitable
format and retrieve in any format needed". So don't save 25 identical
forms
just because you need 25 sets of similar information.

It's very suitable for Excel. I'd use a Userform for entry, not a
worksheet,
and save the raw data in a worksheet; 1 row only per record. See
http://www.contextures.com/xlUserForm01.html

HTH. Best wishes Harald

--

Dave Peterson