Guidance please.

Hi, I am Ariffin from Singapore. I just joined this forum today. I was googling for for excel tips when i chanced this forum. First and foremost i have not studied or have any knowledge in VBA. I found a few ebooks and have been practising and understanding them along the way while i attempt to solve a personal challenge.

I am planning to make a simple program where i press a button and a form pops up asking me whether i wanna key in new data or search from existing one. the data just consist of 2 heading ( name of place and serial number). i have several name of places and its individual serial number to go with it. I have read from pivot tables to creating the form.. but how do i auto sort the data i fill in but the names of places and the serial number. and how do i do a search function when i search for a specific name and serial on a form. Any guidance will be greatly appreciated. I have ready for dummies book.. They are good but i cant seem to find the right commands that i can use for my program.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.