LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling only cells for rows with content Colin Hayes Excel Worksheet Functions 1 April 28th 07 02:46 PM
Adding a constant to a formula. Problems w/filling in zuri125 Excel Worksheet Functions 4 February 3rd 06 06:16 AM
adding content to a cell cedtech23 Excel Programming 2 January 31st 06 07:53 PM
Automatically filling in cells based on another cell's content Ginger Excel Worksheet Functions 5 September 2nd 05 09:17 AM
Filling a cell based on the content of another cell Bill Excel Programming 14 January 28th 05 12:07 AM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"