Using a macro to find matching numbers within tables

Hello all hope every is doing well.

I was wondering if there is a way to create a macro (or formula?) to highlight numbers in tables above it that match the numbers within the specified column and table.

In the sample, in the the table at the bottom (Labeled TABLE in red), I highlighted the numbers in the column heading labeled t11 in red and highlighted in red the numbers that match those numbers in the 3 tables above it (hopefully I didn't miss any).

Is there a macro that would highlight these numbers automatically in the above 3 tables.

Note: the macro would have to be flexible because sometimes I may want to match the numbers in any other column like those in column heading t13 (highlighted blue to differ it from the previous numbers) or any other column in the table.

A second sample (stock comparison 2) has been added to show the tables in different positions and matching a different header (t15)

Originally Posted by Artik

Below not very effective macro, but in small areas perhaps enough.

Please Login or Register  to view this content.

Artik

Is there a way to make it adaptable..for example, I included a sample 2 (stock comparison 2 in original post) where the tables are moved down (no longer between B7-B37) and using the header on the bottom table of t15 at the end (P44).

Is there a way to make the macro use the current selection (selected header) and match to the 3 tables above it as in the samples

Note: the tables will always be in the same relative position in reference to each other.

Originally Posted by Artik

Assumptions for the operation of the following macro:
1. between the last and penultimate table there is an empty row (in the example "Stock comparison 2", row 43 is empty).
2. between the first three tables, the rows are not empty (cells C22 and C32 contain the value "lm" and there are formulas in rows 23 and 33)

Color the fonts in the selected column in the last table and select the cell with the header. Run the macro.

Please Login or Register  to view this content.

The task can, of course, be solved in 100 other ways, analyzing the location and content of the tables in more detail. For now, this is one of the simplest solutions.

Artik

This works beautifully and exactly the way I wanted.

Thank you Artik

If I added 2 tables under the same table as in sample 3 (stock comparison 3) , could this macro be adjusted so that it would compare the 3 tables above it and also 2 tables below doing the same thing. Also it didn't seem to bold the the colors?..can the macro bold the colors too?
And again the relative positions of the tables stay the same