Inout data into rows

[digi duck]

Hi i am not very good at excel and was hoping somone here could help me. I am making a league table and it has 4 sheets (League, Next matches, Profile's, Admin) What i would like to do is to go on to the "Admin" section and have some options such as new player, results. I would like these to be text box's that when i fill in and click submit it adds a new player etc. to the next available row. Any help will be greatly appreciated.

[Mike Fogleman]

Select anywhere in the player data table and click on the menu DATA>FORM.

Mike F
"digi duck" <[email protected]> wrote
in message news:[email protected]...
>
> Hi i am not very good at excel and was hoping somone here could help me.
> I am making a league table and it has 4 sheets (League, Next matches,
> Profile's, Admin) What i would like to do is to go on to the "Admin"
> section and have some options such as new player, results. I would like
> these to be text box's that when i fill in and click submit it adds a
> new player etc. to the next available row. Any help will be greatly
> appreciated.
>
>
> --
> digi duck
> ------------------------------------------------------------------------
> digi duck's Profile:
> http://www.excelforum.com/member.php...o&userid=34965
> View this thread: http://www.excelforum.com/showthread...hreadid=547018
>

[Paul Lautman]

digi duck wrote:
> Hi i am not very good at excel and was hoping somone here could help
> me. I am making a league table and it has 4 sheets (League, Next
> matches, Profile's, Admin) What i would like to do is to go on to the
> "Admin" section and have some options such as new player, results. I
> would like these to be text box's that when i fill in and click
> submit it adds a new player etc. to the next available row. Any help
> will be greatly appreciated.

The simplest method is to go to the table in the profiles section and use
the menu Date->Form...

[digi duck]

thanks i figured it out