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 a

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

--
Message posted from http://www.ExcelForum.com