adding content to a table by filling a sheet
 

Hello

I know this probably is a easy task to most of you but i'm quite a new
excel user.

here it goes:
I would like to create a sheet or a row with two or three cells where
the user can enter data (coordinates). (A text on the sheet says for
instance "Input point 1".
Then, by pushing a button (marked "add" or something like that) , the
data in the sheet or row should be added to a table and the cells in
the sheet should be cleared so that the user can "Input point 2" -
"add" - the second row in the table is added.... and so on until the
user is done and presses the "End" button. (The amount of points is not
set from the start, instead they are added to the table until the user
has no more points to add).

The coordinates in the table will later be used to draw a chart... but
I think I can handle that myself.

I don't know if this is bast done in macro or something, as I wrote I'm
just a beginner at this.:(

Thanx to all of you who tries to help me with this, and sorry for my
bad English.

Best regards, W


--
Borgas
------------------------------------------------------------------------
Borgas's Profile: http://www.excelforum.com/member.php...o&userid=28660
View this thread: http://www.excelforum.com/showthread...hreadid=553078

adding content to a table by filling a sheet
 

Hi Borgas,

Consider using the built in DataForm featu

Menus | Data | Form


---
Regards,
Norman


"Borgas" wrote in
message ...

Hello

I know this probably is a easy task to most of you but i'm quite a new
excel user.

here it goes:
I would like to create a sheet or a row with two or three cells where
the user can enter data (coordinates). (A text on the sheet says for
instance "Input point 1".
Then, by pushing a button (marked "add" or something like that) , the
data in the sheet or row should be added to a table and the cells in
the sheet should be cleared so that the user can "Input point 2" -
"add" - the second row in the table is added.... and so on until the
user is done and presses the "End" button. (The amount of points is not
set from the start, instead they are added to the table until the user
has no more points to add).

The coordinates in the table will later be used to draw a chart... but
I think I can handle that myself.

I don't know if this is bast done in macro or something, as I wrote I'm
just a beginner at this.:(

Thanx to all of you who tries to help me with this, and sorry for my
bad English.

Best regards, W


--
Borgas
------------------------------------------------------------------------
Borgas's Profile:
http://www.excelforum.com/member.php...o&userid=28660
View this thread: http://www.excelforum.com/showthread...hreadid=553078