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