I would like to add data to last row of each sheet daily,by using a data
entry user form.The necessary fields are 1.sheet name,2.date,3,points
earned.fields 2 and 3 are common(column headings)to all sheets.Is this
possible?

Excel has data|form built in. Maybe it'll be sufficient.

If not, you could build your own userform.

Debra Dalgleish has some notes:
http://www.contextures.com/xlUserForm01.html

TUNGANA KURMA RAJU wrote:

I would like to add data to last row of each sheet daily,by using a data
entry user form.The necessary fields are 1.sheet name,2.date,3,points
earned.fields 2 and 3 are common(column headings)to all sheets.Is this
possible?

--

Dave Peterson

I know there is built in user form,but it is meant for one sheet only.I am
looking for a w/book data add user form.Code has to be changed to add data on
w/book sheets.

"Dave Peterson" wrote:

Excel has data|form built in. Maybe it'll be sufficient.

If not, you could build your own userform.

Debra Dalgleish has some notes:
http://www.contextures.com/xlUserForm01.html

TUNGANA KURMA RAJU wrote:

I would like to add data to last row of each sheet daily,by using a data
entry user form.The necessary fields are 1.sheet name,2.date,3,points
earned.fields 2 and 3 are common(column headings)to all sheets.Is this
possible?

--

Dave Peterson