Auto add new text to blank line on 2nd sheet

[T.S.]

I'm working with a workbook containing 2 sheets. We reuse the same form to
keep track of new contacts. What I want to be able to do is enter
information on the first sheet and have it automatically be carried to sheet
2's first blank row. Right now, each time I fill in the first sheet, it
overwrites the first row of sheet 2. Does anyone know how to do this?

Thanks in advance

Terry S.

 

[Debra Dalgleish]

Instead of using a separate sheet for data entry, the Data Form may do
what you need. (Select a cell in the table on sheet 2, choose Data>Form)

Or, try John Walkenbach's Enhanced Data Form. It's free, and has
additional capabilities.

http://j-walk.com/ss/dataform/index.htm