countif column from other worksheet equals certain value, dynamic rows macro

[bookworm121]

Hi!

So i'm trying to count how many rows in worksheet1 have the word "hello" in column F. This information has to be displayed in worksheet 2 in column B row 3.

The amount of rows I want to go through in column F from worksheet1 may vary. It might be 10 now, 15 tomorrow, 123 the day after.

I need to write a macro for this.

Thanks for ur help!

 

[DebugGalpin]

Hi!

So i'm trying to count how many rows in worksheet1 have the word "hello" in column F. This information has to be displayed in worksheet 2 in column B row 3.

The amount of rows I want to go through in column F from worksheet1 may vary. It might be 10 now, 15 tomorrow, 123 the day after.

I need to write a macro for this.

Thanks for ur help!

Does it need to be a macro can in not just be this formula?

=COUNTIF(Sheet1!$F:$F,"hello")