I would like to know if the following problem can be solved using macro's:

I would like to reference the contents, after applying a normal column filter, from a absolute row number to a cell. After applying a filter, a different contents will be showed in this absolute cell. This variable value needs to be displayed in the 'result' cell.

Example:

The result of the value of cell B2 is allways the value of row 4, column A.

Filter starting at cell A2. when I use the filter and select only value 2, the result in cell B2 should be 2. When I apply a filter on the value 1, the result of cell B2 should be 1. So the formula in cell B2 or the macro, should alwayse use the value of the second row, instead of the value of cel A2...
A2=1
A3=2
A4=3
A5=4

Thanks for helping out,
Jurre Thoes