View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.