Row ID generation

I want to create macro that would Enter ID number in column A if value is
entered in column B. For example i have following

How do i execution of code if any value is entered in certain column' cell ?
For example i want to enter value in column A if ANY value is entered in
column B

Example:
A B C
1 1 aaa
2 2 bbb
3

I want to create code that would enter next number in column A if i enter
any value in column B.
Value A2+1 should be entered in cell B3 if i enter value "s" in cell B3.
Like this

A B C
1 1 aaa
2 2 bbb
3 3 s

You need two different codes.
Formula for cell A1
Another formula for all the other cells in column A

in A1 put =IF(B1="","",1)
in A2 put =IF(B2="","",A1+1)

Then copy A2 all the way down
--
Gary's Student


"Mikus" wrote:

> I want to create macro that would Enter ID number in column A if value is
> entered in column B. For example i have following
>
> How do i execution of code if any value is entered in certain column' cell ?
> For example i want to enter value in column A if ANY value is entered in
> column B
>
> Example:
> A B C
> 1 1 aaa
> 2 2 bbb
> 3
>
> I want to create code that would enter next number in column A if i enter
> any value in column B.
> Value A2+1 should be entered in cell B3 if i enter value "s" in cell B3.
> Like this
>
> A B C
> 1 1 aaa
> 2 2 bbb
> 3 3 s

Thanks garry ... i can't understand why i did not come up with this myself

I think i will use ISBLANK(B1) instead of B1="" though

"Gary's Student" wrote:

> You need two different codes.
> Formula for cell A1
> Another formula for all the other cells in column A
>
> in A1 put =IF(B1="","",1)
> in A2 put =IF(B2="","",A1+1)
>
> Then copy A2 all the way down
> --
> Gary's Student
>
>
> "Mikus" wrote:
>
> > I want to create macro that would Enter ID number in column A if value is
> > entered in column B. For example i have following
> >
> > How do i execution of code if any value is entered in certain column' cell ?
> > For example i want to enter value in column A if ANY value is entered in
> > column B
> >
> > Example:
> > A B C
> > 1 1 aaa
> > 2 2 bbb
> > 3
> >
> > I want to create code that would enter next number in column A if i enter
> > any value in column B.
> > Value A2+1 should be entered in cell B3 if i enter value "s" in cell B3.
> > Like this
> >
> > A B C
> > 1 1 aaa
> > 2 2 bbb
> > 3 3 s