Student need Help with Table of data

[totallyconfused]

Hey
There are a few things i would like to create on my spreadsheet howeve
i have an idea of how to do it but dont know how can anyone help? th
things are:

1. If i have a table of pupil data and there is a command button name
Add new person, when you click on this button a form appears once yo
filled in the information on this form and clicked another button name
OK the new information will automatically be listed with the the othe
data of people as a new record.
HOW IS THIS DONE?

2. If you have data of students and you want to search through it, I
there a way where you could type in details you are looking for of
certain person on a form on another sheet in excel and then select
command button named SEARCH and it will find it for you?

HOW IS THIS DONE? Need Macros, forms??? lookup???

thank you :confused

 

[Bob Kilmer]

totally,

Do 1 something like this:
Open a workbook. Press Alt+11. Add a "userform" to your project. Put a
button on it. Change Caption to "OK". Put text boxes on userform for input.
Double-click the OK button. In the the click event handler (called like
Command1_Click()), place code that wites the textbox contents to the
worksheet; something like Range("A1").Value = TextBox1.Text,
Range("B1").Value = TextBox2.Text, etc.. Add a button to the worksheet.
Right-click, View Code. Add (like) Userform1.Show to click event handler.
Try it.

Use what you learn in 1 to do 2.

Consider Range("A1:Z26").Find(.... Look up Find method of Range object.

Bob