Buttons in table reference cells in table

[Alkuan]

I'm trying to make a database where i have two sheets, one to store the data, and the second to display some of that data in a sortable Excel Table. The reason I am doing this is so I can have a button which displays the next cell is a sequence of operations. I'm current doing this by deleting the referenced cell. (see image below) If there is a better way to achieve this functionality (in one sheet?), i would be very open to change. I have attached a copy of my workbook with confidential data removed.

\1
opexample.PNG

I added buttons in the last rows of the table to bring you to the correct row in the data storage sheet when clicked (one just selects it, one deletes a cell, and one deletes the entire row). Everything works fine until i reorder the table, or only display part of the table. When I change the order of the rows and click the GoTo button, it now brings me to whatever part was originally in that line.

\1
Parts Tracker.PNG
Screenshot of Excel Table

This is the code i am using to select the appropriate row in the data storage sheet.

Please Login or Register  to view this content.

I really appreciate your help on this problem. Hopefully there is a simple workaround, but i'm not experienced enough to come up with an alternative!

[Alkuan]

So i think i managed to fix the problem by reducing the size of the buttons from filling the entire cell to being contained within it.

Please Login or Register  to view this content.

No idea why this works, but it does seem to do the trick.