 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007A Form To Feed An Excel Worksheet
Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a mini-database with names and addresses, etc. to feed into a Word 2007 mail merge. Typing in all the data in the Excel worksheet is going to be tedious. I'm wondering if there is something equivalent to a "form" that you can create in Access. In Access, a "form" is something with fields that you can group in a convenient order on the "page" of the form, and then you can tab through them and type in data. I think one could create such a thing in Access, and feed an Access database. I'm hoping the equivalent thing can be created in Excel. If you have any information that applies to earlier versions of Excel, I'm sure that will still be useful info for the 2007 version. Thanks. dc In Excel version 2003 I would check out Data > Form... But don't know the 2007 equivalent.  SignatureWigi http://www.wimgielis.be = Excel/VBA, soccer and music > Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a > mini-database with names and addresses, etc. to feed into a Word 2007 mail [quoted text clipped - 10 lines] > > dc > In Excel version 2003 I would check out Data > Form... > > But don't know the 2007 equivalent. I can't find the 2007 equivalent either. There's no "Form" on the Data ribbon and searching for "data entry form" in Help yields no decent results. Neither does right clicking on selected cells to create such a form. Did MS take out this feature? Bill I found this link on the net after spending many hours trying to get excel 2007 data form to work. j-walk.com/ss/dataform. I have down loaded this version free of charge and it works ok(j.walk enhanced data form v2). EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com "DeeDeeCee" escribió > Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a > mini-database with names and addresses, etc. to feed into a Word 2007 mail [quoted text clipped - 14 lines] > > dc Hi Dee This command is availlable from the Excel Options area in Excel 2007. You can add it to the Quick Access Toolbar if you use it often. To add a command to the Quick Access Toolbar: 1.Click the microsoft office Button, and then click Excel option. 2.Click customize. 3. In the Choose commands from list, click All commands, and then find the commad form... http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT101493291033&vwidt h=1044&vheight=788&type=flash&CTT=11&Origin=HA101491511033 infinitogool > "DeeDeeCee" escribió >> Hi. I'm creating an Excel worksheet in Excel 2007. It is going to be a [quoted text clipped - 30 lines] > > infinitogool Thanks! MS sure hid that feature pretty well in Excel 2007! Bill
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.