ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   EXCEL (https://www.excelbanter.com/excel-worksheet-functions/8260-excel.html)

KristenNEEDShelp

EXCEL
 
I need to create a form/worksheet for inputting suvey ianswers that will be
dumped into one spreadsheet/data base (USING EXEL). Anyone have any
suggestions?

Norman Jones

Hi Kristen,

One option would be to use Excel's built-in Data Form.

Type the survey response headings into (say) the first row of a worksheet.
With one of the header cells selected,:
Data | Form... | OK

See Excel's help topic: Enter data in a Microsoft Excel list by using a
form.

If this approach is satisfactory, you might also wish to look at John
Walkenbach Enhancd Data Form which is freely downloadable at:

http://www.j-walk.com/ss/dataform/


---
Regards,
Norman



"KristenNEEDShelp" wrote in
message ...
I need to create a form/worksheet for inputting suvey ianswers that will be
dumped into one spreadsheet/data base (USING EXEL). Anyone have any
suggestions?




JE McGimpsey

Check out John Walkenbach's free Enhanced Data Form:

http://j-walk.com/ss/dataform/index.htm




In article ,
"KristenNEEDShelp" wrote:

I need to create a form/worksheet for inputting suvey ianswers that will be
dumped into one spreadsheet/data base (USING EXEL). Anyone have any
suggestions?



All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com