Input data in an excel table
 

I have a 5 columns table that I have to fill with information. I saw once a
way to create a table that displays the title of each column, and a window
where I can write the data, and the information will be placed in its
adecuated column. But I cannot remember How to do it.

Input data in an excel table
 

DataForm?

Preselect the 5 columns and give them the name of "database"(no quotes) via
InsertNameDefine.

Select a cell in that range and DataForm


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 14:45:02 -0800, "Willis in crisis"
wrote:

I have a 5 columns table that I have to fill with information. I saw once a
way to create a table that displays the title of each column, and a window
where I can write the data, and the information will be placed in its
adecuated column. But I cannot remember How to do it.