Hi,

I need to be able to

1) find the last filled cell in a row ( for 2000 rows)

2) replace the value in that cell with a certain text ("YES")

I am not sure where to start and what formula/function to apply.

Could you please help?

Thank you!

A_K

I need to be able to

1) find the last filled cell in a row ( for 2000 rows)

2) replace the value in that cell with a certain text ("YES")

I am not sure where to start and what formula/function to apply.

Could you please help?

Thank you!

A_K

Last edited: