auto numbering in previous cell based on enter adjacent cell using target cell

[Hasson]

Hello
I have headers in row10 and data starts from row11. I want when entering data in column B , then should autonumbering in column A 1,2,3 ....
just when fill in cell for column B then should fill in previous cell in column B using target range by sheet module .
thanks

 

[fjns]

Hi, try this formula for cell A11
=IF(B11="","",ROW()-10)
Then drag the formula of cell A11 down.

 

[Hasson]

thanks
I don't say to want the formula !
did you read title of thread and my details?

using target cell​

target range by sheet module .

this means code in sheet module by use cell target .

 

[My Aswer Is This]

Please help me help you.
So if you enter any value in Column B starting in Row 11
You want "1" entered in in Range("A11")

And if you enter any value in Range("B12") you want "2" entered in Range("A12")

Is this correct?
And the script will be run to do this when you enter any value in Column B starting in Row 11

 

[Hasson]

@My Aswer Is This
yes all of what you said correct
Thanks

 

[My Aswer Is This]

Try this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Row > 10 Then
Target.Offset(, -1).Value = Target.Row - 10
End If
End Sub

 

[Hasson]

@My Aswer Is This
exactly this is what I look for it .
thank you so much .

 

[My Aswer Is This]

@My Aswer Is This
exactly this is what I look for it .
thank you so much .

Glad I was able to help you. Take care and come back here next time you need help with Excel

 

[Hasson]

@My Aswer Is This
I've found there is problem , if I press inside the cell without write any thing also will populate number in cell for column A despite of the pressed cell in column B still is empty , how could fix it ,please?

 

[My Aswer Is This]

@My Aswer Is This
I've found there is problem , if I press inside the cell without write any thing also will populate number in cell for column A despite of the pressed cell in column B still is empty , how could fix it ,please?

The script will only run if you enter a value in column B

Do not understand what you mean when you say.
A despite of the pressed cell in column B still is empty , how could fix it ,please?

If you mean when you press the spacebar?
Pressing the spacebar enters a space the script does not exclude spaces.

If you delete the value in column A and then decide to delete the value in column B the script shows this as a change and will again put a value in column A

Not sure how many other things you may want to do in column B and what the results you may want in column A

Not sure what this means:
You wrote:
I press

What does press mean?