Updating VBA focused on highlighting active cell at top of worksheet

[lipovsas]

I'm new to VBA and coding in general but trying to test my capabilities by updating a macro I found online. The goal is for the macro to display the active cell I have highlighted at the top of the worksheet--and ultimately run a number of equations off of that output. This does that job:

Please Login or Register  to view this content.

However, I'm curious if I can change the output displayed at the top of the sheet to be whatever is in Column B of the highlighted row. No matter where the user is selecting a cell, such as H1960, cell C3 would show the contents of B1960. Is that possible?

Thank you

[kalbasiatka]

Target.Value

[lipovsas]

Target.Value

Sorry where do I put that?

[AliGW]

@Kalbasiatka - if you are going to help, you need to explain the suggestions you are making. This is not the first time I have noticed unacceptably brief responses from you. Please respond appropriately and with guidance. Thank you.