excel question.

[Paul11]

can excel make a form type view. so that you can enter a name and email address (and maybe an amount of money) in the form view .. ie the top row of excel, or boxes that i made to type in to

and when you hit enter, it would add that person to the list ?


so you would not need to keep scrolling down to the bottom of the list to add people, you could just keep typing on the top line for example, like entering info in to a form

 

[miniyazz]

I suspect you could do some such thing using a macro. Something like: name in E1, email address in F1, amount of money in G1, then a shortcut key that you press once those fields are filled in (Ctrl-Shift-A, for example). This would run the macro.
The macro itself would go to A1 and work down the list until it finds a cell in the A column that is blank (you could add redundancy by then checking the B and C cells next to it are also blank) and when it finds the blank cell, it moves the contents of E1 to that cell, the contents of F1 to the cell next to it, and G1 to the cell next to that. Then it could return to the top of the document.
Have a play with it, and see what you can make it do!

There's probably a more elegant solution out there, but I think this would work.