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?
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks