NEED URGENT HELP.

[AJ_121]

Dear,
I am new in excel and i need a help that which cell i select from the whole sheet that name/number/data automatically should be show on Cell B2.


Example i am sharing via image attached, in this image someone has selected Cell N2 and that is showing on Cell P2. Wherever he clicks that cell data comes on Cell P2.
How i can do this please help.

 

[Peter_SSs]

Firstly, in relation to the urgency of your request, please note 5g and 5h of the forum Guidelines


Try this Worksheet_SelectionChange event code. To implement ..
1. Right click the sheet name tab and choose "View Code".
2. Copy and Paste the code below into the main right hand pane that opens at step 1.
3. Close the Visual Basic window & test.
4. Your workbook will need to be saved as a macro-enabled workbook (*.xlsm).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Range("B2").Value = ActiveCell.Value
End Sub

 

[AJ_121]

I'm really sorry sir.

Next time i'll take care of it.

Thank you so much for your help.?

 

[Peter_SSs]

Thank you so much for your help.?

You're welcome. Hope it is what you wanted.