Thread: Pointer please
View Single Post
  #2   Report Post  
Harald Staff
 
Posts: n/a
Default

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