Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms that Populate Excel Worksheet?
I would like to develop a form that people can open, fill in the blanks and
hit enter. The data from the form that populates an Excel worksheet. Suggestions on how to do this in Excel or other Microsoft products would be appreciated. I use Excel 2003 on a PC and Excel 2004 on a Mac |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms that Populate Excel Worksheet?
Excel has a built in form under the Data Menu. Provided that it can recognise
Column Headings (Say Bold) then with the active cell somewhere in the list choose Data, Form. The form shows each column header, any formulas are grey out and automatically added to a new item. You can Add new Data, Delete old Data, Edit and search for records. A more advanced form would need code to perform the required operations. Regards Peter Atherton "an" wrote: I would like to develop a form that people can open, fill in the blanks and hit enter. The data from the form that populates an Excel worksheet. Suggestions on how to do this in Excel or other Microsoft products would be appreciated. I use Excel 2003 on a PC and Excel 2004 on a Mac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically populate forms | Excel Worksheet Functions | |||
Populate Order worksheet from Quote worksheet | Excel Worksheet Functions | |||
populate cell on worksheet 2 if text is red on worksheet 1 | Excel Worksheet Functions | |||
can excel populate fields in one worksheet to another? | Excel Worksheet Functions | |||
create a userform to populate a diagram with the forms info | Excel Discussion (Misc queries) |