A Form To Feed An Excel Worksheet

[DeeDeeCee]

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

 

[Wigi]

In Excel version 2003 I would check out Data > Form...

But don't know the 2007 equivalent.

 

[Bill Sharpe]

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

 

[infinitogool]

"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
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

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/assista...t=788&type=flash&CTT=11&Origin=HA101491511033

infinitogool

 

[Bill Sharpe]

"DeeDeeCee" escribió

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/assista...t=788&type=flash&CTT=11&Origin=HA101491511033


infinitogool

Thanks! MS sure hid that feature pretty well in Excel 2007!

Bill

 

[sue hourigan]

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