Count Text across multiple sheets

[normilet]

Ok so I have a workbook with 29 sheets.

28 of those sheets contain a column with text data in them.

The text data in each column sometimes contains duplicate fields from sheet to sheet.

What I want to do is fill the 29th sheet with one column containing all of the other sheets names, and one row containing all of the different text fields from the data column without any duplicates. That part has already been completed manually, however, if a new text field had to be added to a certain sheet, I would need that new field to be automatically added to the new Master sheet into the row containing all the different text fields from the data columns.

Then for each name in my new 29th sheet, I want to put an "x" in the row/column cell if that text data appears in the individual sheets data column.

E.g I have 2 sheets. The first one is called Apples, the text data column might say: green, smooth, sour etc, with each word in an individual cell.
The second sheet is called Oranges, the text data column might say: Orange, smooth, round, sour etc.

I want to fill my new master sheet with a column listing the two sheet names (Apples, Oranges), a row with all the possible text data names without duplicates (Green, Orange, smooth, sour, round in our example), and then I want to input an "x" wherever the sheet name contains specific text data from the newly created row. In this case I would expect to see:



apples.png

[Bernie Deitrick]

Add this code to a regular codemodule, and run it first, and then again whenever you want to fully update the summary sheet: change the letter "B" to the column letter of your "column with text data" in both procedures, and save your workbook as a macro-enabled .xlsm

Please Login or Register  to view this content.

Then add this code to the codemodule of the Thisworkbook object, to automatically update the Summary sheet when values are added to the other sheets.

Please Login or Register  to view this content.

[normilet]

Thank you, that worked absolutely perfectly first time round, no issues whatsoever.