Count Word Occurrences from a different tab

How could this be written in VBA?

Please Login or Register  to view this content.

It is written in VBA, is it not? Maybe you are just looking for an alternative. Here is one of many ways:

Please Login or Register  to view this content.

I dig it, thank-you,

Please Login or Register  to view this content.

If I had 10 cells to do this in, what would be the best way? Create 10 separate Subs?

What cells do you want to do it in and do you still want to look through the same column? Honestly using the countif function you submitted is probably going to be best, i just figured I would show you a different way.

you arent going to need 52 different subs. I just don't clearly understand what you are trying to do at this point so I can't write it into 1 vba script. Maybe this is what you need (you will definitely need to adjust to match your needs):

Please Login or Register  to view this content.

I have 50+ tabs on a worksheet, all state/country abbreviations. In one column on my Metrics tab I am counting the number of times the word Manual appears, and in another column the number of times Yes appears from each of the state/country tabs. I had formulas written in the cells, I am trying to remove them since so many people are in and out of the worksheet, and to prevent corruption of the data.

I will try the suggestion that has been added a little later.

When I run this in Debug it works fine, all the cells populate, but it does not refresh. Would I have to use Ctrl + "whatever" to prompt it, or is there a way to make it automatic?

Please Login or Register  to view this content.

I got this working perfectly with some adjustments, just how I want it. Thank-you for the help.

Please Login or Register  to view this content.