I want to create a data entry form that will put the new data at the end of a
list. The form would include first and last names, and few dates. Any ideas

Brian

Excel already has a data form under DataForm.

New entries are placed at the end of a list.

Basics..................

1. Type labels in A1:C1 First, Last, Date

2. Select A1 and DataForm. Click OK when asked if you want to use row 1 as
labels.

Start entering data.


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 12:20:08 -0800, Brian T
wrote:

I want to create a data entry form that will put the new data at the end of a
list. The form would include first and last names, and few dates. Any ideas

Now do I have to run that each time I want to add another record or will it
stay?

"Gord Dibben" wrote:

Brian

Excel already has a data form under DataForm.

New entries are placed at the end of a list.

Basics..................

1. Type labels in A1:C1 First, Last, Date

2. Select A1 and DataForm. Click OK when asked if you want to use row 1 as
labels.

Start entering data.


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 12:20:08 -0800, Brian T
wrote:

I want to create a data entry form that will put the new data at the end of a
list. The form would include first and last names, and few dates. Any ideas

Do I have to run that each time I want to add a record or will it stay

"Gord Dibben" wrote:

Brian

Excel already has a data form under DataForm.

New entries are placed at the end of a list.

Basics..................

1. Type labels in A1:C1 First, Last, Date

2. Select A1 and DataForm. Click OK when asked if you want to use row 1 as
labels.

Start entering data.


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 12:20:08 -0800, Brian T
wrote:

I want to create a data entry form that will put the new data at the end of a
list. The form would include first and last names, and few dates. Any ideas

You can add as many more rows as you want without dismissing that dialog. But
if you close that dialog, then decide you want to add more, you'll have to
reshow the dialog.



Brian T wrote:

Do I have to run that each time I want to add a record or will it stay

"Gord Dibben" wrote:

Brian

Excel already has a data form under DataForm.

New entries are placed at the end of a list.

Basics..................

1. Type labels in A1:C1 First, Last, Date

2. Select A1 and DataForm. Click OK when asked if you want to use row 1 as
labels.

Start entering data.


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 12:20:08 -0800, Brian T
wrote:

I want to create a data entry form that will put the new data at the end of a
list. The form would include first and last names, and few dates. Any ideas



--

Dave Peterson

Thanks for jumping in.

Some other part of my life intruded on my time.

You didn't know I had a "some other part" did you<g

On Tue, 27 Feb 2007 15:27:44 -0600, Dave Peterson
wrote:

You can add as many more rows as you want without dismissing that dialog. But
if you close that dialog, then decide you want to add more, you'll have to
reshow the dialog.



Brian T wrote:

Do I have to run that each time I want to add a record or will it stay

"Gord Dibben" wrote:

Brian

Excel already has a data form under DataForm.

New entries are placed at the end of a list.

Basics..................

1. Type labels in A1:C1 First, Last, Date

2. Select A1 and DataForm. Click OK when asked if you want to use row 1 as
labels.

Start entering data.


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 12:20:08 -0800, Brian T
wrote:

I want to create a data entry form that will put the new data at the end of a
list. The form would include first and last names, and few dates. Any ideas

Something to do with Word or PPT??? <vbg

Gord Dibben wrote:

Thanks for jumping in.

Some other part of my life intruded on my time.

You didn't know I had a "some other part" did you<g

On Tue, 27 Feb 2007 15:27:44 -0600, Dave Peterson
wrote:

You can add as many more rows as you want without dismissing that dialog. But
if you close that dialog, then decide you want to add more, you'll have to
reshow the dialog.



Brian T wrote:

Do I have to run that each time I want to add a record or will it stay

"Gord Dibben" wrote:

Brian

Excel already has a data form under DataForm.

New entries are placed at the end of a list.

Basics..................

1. Type labels in A1:C1 First, Last, Date

2. Select A1 and DataForm. Click OK when asked if you want to use row 1 as
labels.

Start entering data.


Gord Dibben MS Excel MVP

On Tue, 27 Feb 2007 12:20:08 -0800, Brian T
wrote:

I want to create a data entry form that will put the new data at the end of a
list. The form would include first and last names, and few dates. Any ideas



--

Dave Peterson