I currently have a VBA macro which identifies a specific row in a table based on the value in the first column and returns that entire row on another worksheet. I then have a macro that selects the row above and returns that row. However, when I filter the table the macro that selects the row above doesn't take the filtered table into account since the row numbers haven't changed.

Is there a way for the macro to return the row above in the filtered table? So if I'm currently "in" row 23 and the row above in the filtered table is row 3, I want the macro to return the values in row 3 and not row 22.

Clarification of the workbook setup:

The table is on the sheet called "Uppdragslista".
The value in N9 at the sheet called "Redigering" is used for identification of a certain row in the table.
The row-data is put on sheet "Redigering"

Current macros:

Identifying row based on cell value in another sheet:

Please Login or Register  to view this content.
Taking values from the row above:

Please Login or Register  to view this content.