How to..use worksheet form and save data to an Excel list
 

I'm using Excel 2003.

Is is possible to create a worksheet form where the user enters data, saves
the data and the data is then saved to the last row in an Excel list?
Once the data is saved by the end user, I would like the form to refresh so
that the end user can continue entering additional data.

Does anyone know of any documentation or examples I could review regarding
the above as I have never done this before?

TIA.

Maybe just Data|Form would be sufficient.

If that doesn't fit your needs, look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

Jan wrote:

I'm using Excel 2003.

Is is possible to create a worksheet form where the user enters data, saves
the data and the data is then saved to the last row in an Excel list?
Once the data is saved by the end user, I would like the form to refresh so
that the end user can continue entering additional data.

Does anyone know of any documentation or examples I could review regarding
the above as I have never done this before?

TIA.

--

Dave Peterson

Thank you, I'll check the site you mention because Excel's data form doesn't
allow you to use combox, etc.

"Dave Peterson" wrote:

Maybe just Data|Form would be sufficient.

If that doesn't fit your needs, look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

Jan wrote:

I'm using Excel 2003.

Is is possible to create a worksheet form where the user enters data, saves
the data and the data is then saved to the last row in an Excel list?
Once the data is saved by the end user, I would like the form to refresh so
that the end user can continue entering additional data.

Does anyone know of any documentation or examples I could review regarding
the above as I have never done this before?

TIA.

--

Dave Peterson