Collecting data from Excel form

[Ricki Miles]

I am working in Excel 2003 and would like to know if there is a way to
create a form for data fill-in so that the data would then be collected in a
database elsewhere.

Thank you,

Ricki

 

[Lee Li Fong]

Ricki,

You can go to http://smartusemicrosoftoffice.blogspot.com/2010/03/linking-data-from-form-to-database.html to see it is the solution you want. Hope can help me.

 

[Ricki Miles]

Thanks for the post. his is the task I would like to accomplish, but there
are no instructions on how to accomplish this task., just a screen shot on
what will happen. Where can I find the instructions to get this to work?

Thanks,

Ricki

 

[Gord Dibben]

Ricki

Excel can do this.

Define "elsewhere" for more specific help.


Gord Dibben MS Excel MVP

 

[Ricki Miles]

By "elsewhere", I mean another spreadsheet in the same workbook. The data
filled in certain cells from sheet1 would be gathered and placed in a
database in sheet2.

Thanks,

Ricki