You could use some built-in features of excel that may work ok.
In xl2003 and below, you can use Data|Form.
(try it on some test data)
And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm
And the source code is available for a small fee ($20 USA, IIRC).
And if that's not sufficient, then maybe you could design your own input
userform.
Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html
Steen wrote:
Hi
I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.
What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?
/Steen
--
Dave Peterson