Good afternoon,
I have a macro that returns the records, it's called "traer_dato".
In cell "I10" I write the reservation number and when i press the "SEARCH" button must torn me back the last record.
Is not work, Is bring me back a random record instead of the last record.
In the sheet "BASE DATOS" I have recorded the number 29 several times.
I attach the document.
I hope that you can help me to help it work.
Thanks and sorry for my bad english.
Last edited by Joselica; 05-11-2021 at 04:44 PM.
Hola Joselica,
I checked your macro and it does not seem to find a random match, rather it finds the first one, on line 3, the second line in the table, each time.
I found that the find function can look from the bottom instead by adding a parameter.
I believe that it works as you expect with this update.
Change from
to
Please Login or Register to view this content.
Dos this change work for you ?Please Login or Register to view this content.
Hola Joselica,
If this helped you, please mark as solved
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks