Show values in bottom row when moving up or down through cells

[Vladimir Macedonia]

Hello,
Anyone knows a formula on how can it shows values in any row bottom when moving up or down through cells with values ?

 

[trimmjens]

I'm not sure if there is a formula to do this but you can do it with VBA. Let me know if you need to know how.

 

[Vladimir Macedonia]

Hi trmmjens,
The problem is that the customer don't want to use excel with enabled macros
However, you can show me one example
Thank you in advanci

 

[trimmjens]

I understand.
Lets say you have values in row 1 to 28 in column A to F you can put this code in your sheet in vba.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Cells(30, ActiveCell.Column).Value = ActiveCell.Value

End Sub

This will put the selectet value in row 30 of the active column.
You can modify it so it suits your sheet.

 

[Vladimir Macedonia]

trimmjens,
Simply and great solution for further match/index
Thank You
PLease let me know if it is possible without macro enabled

 

[Vladimir Macedonia]

trimjens,
What about on cell changes, how can i show the changes ?

 

[trimmjens]

Hi,
I'm not sure what you mean. Can you explain further?