anyone know how to solve this?

T

totallyconfused

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

1. If i have a table of pupil data and there is a command button named
Add new person, when you click on this button a form appears once you
filled in the information on this form and clicked another button named
OK the new information will automatically be listed with the the other
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, Is
there a way where you could type in details you are looking for of a
certain person on a form on another sheet in excel and then select a
command button named SEARCH and it will find it for you?

HOW IS THIS DONE? Do you need to do Macros, forms??? lookup???

thank you :confused:
 
J

jeff

Hi,

Your second question is easy: Ctrl+F will bring up
the "Find" functionality. Enter your search text and
hit OK.

The first question obviusly calls for some VBA
programming. To get started, record a simple action,
then view what macro code was produced. Also, go
thru some posts here to see macro code people have
put together. Take small steps, it can be fun.

jeff
 
A

Anders S

There is a simple data input and search form under Data>Form. If you want
something more sophisticated you can create a UserForm in the Visual Basic
Editor, but that takes some programming.

HTH
Anders Silven
 
J

Jeff

Hi,

I worked up the simplest of worksheets for you.
If you'll send me you email address, I'll send
it to you - it would be a good place to start
with your question #1.

Send to: [email protected]

jeff

(remove the NOSPAM)
 
Top