create column headings. (preferably in the top row)

with your cursor on one of the headings, click the data menu, then form..
If you don't have any data yet, Excel will ask you where the headings are,
just click okay.






"hally" wrote:

how would you create that?

"TomHinkle" wrote:

I'd just use the data form...
Simple and no coding..

"bj" wrote:

does the 10 by 10 start out blank?
I can not tell whether the value goes to every cell at the same time or if
it goes into a different cell each time a new value is entered.
What do you want done after the 10 by 10 block is filled?

"hally" wrote:

needs to go into a 10 x 10 table in which each piece of data is put into each
of the tables cells

"bj" wrote:

do you have criteria as to where it goes into the table?

"hally" wrote:

i am trying to create if possible a cell so that when i enter data into that
cell and i press return it enters the data into a table, then deletes the
cell where i originaly entered the data so i can enter some new data.