Get the number of times of text is repeated in some range in several sheets

Copper Contributor

I have a workbook with several sheets.

In the range from B20:B25 I have some values from a drop-down list. In the left column when that values are wrote, the workbook automatically has to set the many times of that value has selected in all sheets simultaneously.

For example if in the sheet 2 I write the text "TEXT" in cell B22, the workbook has to look up in the last sheets if the text "TEXT" exists ONLY at range B20:B25. If this text was found, so the workbook has to add 1 to the left cell of value "TEXT" of the last sheet when the "TEXT" was wrote.

The workbook can have to 60 sheets. And for example the "TEXT" could be wrote at first time in the sheet 55, and its left number must be 1. If the "TEXT" is write again in the sheet 56, the value at its left must be 2.

So the column A must be a counter of times that value in column B is wrote.

SHEET 1SHEET 1

 

SHEET 2SHEET 2

 

SHEET 3SHEET 3

 

 

I tried with CELL, ADDRESS and MATCH but I had not lucky.

Does exists in VBA a formula that I can create something to count such this?

 

Thanks.

0 Replies