ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Inout data into rows (https://www.excelbanter.com/excel-programming/362886-inout-data-into-rows.html)

digi duck

Inout data into rows
 

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


Mike Fogleman

Inout data into rows
 
Select anywhere in the player data table and click on the menu DATAFORM.

Mike F
"digi duck" wrote
in message ...

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

Inout data into rows
 
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[_2_]

Inout data into rows
 

thanks i figured it out


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



All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com