Macros & Inserting programing

[Rayzor500]

I have a spreadsheet that im trying to setup for visitors that come into the church. On Sheet 1 I have 2 buttons that you can create a Client and a search button. When I click on Create a Client I would like for it to jump to sheet #2 so we can put in the information and have it store on Sheet #3 then go down to the next line. The Search button on page #1 I would like to click on it and jump to page #4 so I can type in the name and press enter and it search through the names on page #3. I need all the macros and any scripts. Ive never worked with macros before so if you message me, I can send it to you. Any help will be greatly appricated!

 

[Datsmart]

Take a look at using a UserForm for this.
Good step by step instructions and an example download here:
http://www.contextures.com/xlUserForm01.html

 

[Rayzor500]

Do you know how to write scripts - I was able to create how I wanted it to look but for some reason when I want to click on the save button to add to my database, it is telling me a compling error