Row number-1

[mirrorwatch]

In the scenerio, column A represents row number minus 1.

Meaning the cell value of A2 is 1

A5 is 4

So I need a macro to first see if there is anything in the column B of the row, say if B7="test", then I want A7 to show 6. If B7 is nothing then nothing in A7.

I need the macro to be activated everything there is a value in column B of the row.

 

[Roli001]

I know you asked for a macro but you can get the same using standard Excel functions:

=IF(B7="test",6,"")

Hope this does the job.

 

[mirrorwatch]

I know you asked for a macro but you can get the same using standard Excel functions:

=IF(B7="test",6,"")

Hope this does the job.

erm, thanks

but firstly for the column B if it contains any kind of words(not just "test"), I want the corresponding A column to have the rownumber-1 . How to do this?