Hi, I want to use a macro to do the following. I have a table with data (info about different, a lot of persons...). The first column is a unique number (called 'number') referring to the person. Now I want to use a macro to consult the table by using the 'number'. On a second page I fill in the 'number' and I want that a macro consults the table and gives al the information of the corresponding person on the second page. On this second page I want to do some changes on the information of the person and then I want to put back the corrected information in the table.
What I don't know is how to find the correct row with the information of the person with a certain 'number', both for consulting and re-writing the changed values. I could do it with (advanced search, but I find this not a clean solution) I tried also with 'advanced filter' but this also did not work properly. (relative reference...)
Anybody experience with this.
Thanks a lot.
I'm an amateur in recording macro's and no experience with VBA and forms.