help creating a userfom please

so what i need the user form to do is to search for poeple based on certain criteria and then edit cells according to account so if i get joe bloggs in row "64" the following user form will enter the data on the according row.

1. have a search function that will bring up a list of people determined by - what area they are in ( column D)
- what stage they are at: first stage/ not contacted (if column e is empty)
second stage / contacted (there will be a "y" in column e)
third stage / visited (there will be a "y" column f)

2. then i need to be able to select a person and edit all of the details on their row, so i would need to:

1 for the first stage people who have not been contacted i need to be able to: edit column E, just enter a "y"
edit columb k, enter notes

2 for the second stage people who have been contacted and we have now visited: edit columb F, just enter a "y"
edit column g, a drop down list yes or no
edit columb k, enter notes in addition to previous notes

3 For the third stage people who we have visited and if column g is "yes" : edit columb H, just enter a "y"
edit columb J, just enter text

I know its complicated but if someone could help me it would be a life saver and stop me wasting so much time.

thanks in advance

Isn't this a duplicate of this?

I had a look at your original thread and it doesn't seem particularly complicated to me.

There are some things that need clarification though.

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

So how would you want the userform to work?

A dropdown that lists all the areas and a listbox to display all the contacts for the user selected area?

Then perhaps when the user selects a contact from the listbox there details are loaded into textboxes where they can be edited.

Once edited the user clicks a button and the details for the contacts are updated with the data from the textboxes.

Oh, almost forgot. What details would you want to see on the form for each contact?

Coolblue

Sorry about that, I'll step aside from this and let the professional Excel market take over.

PS Did I break some sort of rule, written or unwritten?

This is from the top of this forum...
http://www.excelforum.com/showthread.php?t=823709

This is also a very good resource...
http://www.cpearson.com/Excel/Topic.aspx

Or you could try this search in google: userform excel

Originally Posted by Norie

Coolblue

Sorry about that, I'll step aside from this and let the professional Excel market take over.

PS Did I break some sort of rule, written or unwritten?

No mate, of course not. Its a free market and yours is the lowest bid: go for it!
I'm just genuinely curious about the economics of that market.