Macro for executing multiple sorting from a list

Hi everyone, i'm pretty new to vba and i'm dealing with a sorting problem.

I have two sheets: the first sheet is for search and display, the second represents my database and contains few columns and thousands of rows.
I would like to insert a particular value in a cell in sheet 1 and having the macro search and display for results.

what my macro shoud do is:

- In sheet1 there should be my "search field" let's say in field "C3" and a "search button" to start the macro.
- In sheet2 the macro has to search for exact value in column "A" starting from second row.
- once found it has to display all columns of selected row in let's say in row 15 of sheet1.

- then it has to look to field "C15" of sheet 1: if it's empty, do nothing, if it's full, take it as the new value for a new search in sheet2 column "A".

- once found correponding value in similar way as before, it has to add a row in sheet1before the one containing the previous results, and dislay the current ones

- and so on until field "C15" in sheet 1 will be empty.

i was trying to duplicate a simple search function but results are really not satisfactory..

any help would be really appreciated thanks

Sorry, i forgot to add the code i'm trying to use, even if i don't think it will be of any help, i'm pretty new to this stuffs..

Please Login or Register  to view this content.