I downloaded your version1 again and I looked in which columns the
indexes are. Then I put these columns in a range and made a version with
find.
Now that the range to look in is not the whole table the macro is faster
than the macro with the formulas.
Have a look in OneDrive for "BlueGrass Version2"


Regards
Claus B.

Yes, that looks very good to me.

The goal was to take the difficult to read info on one sheet and compile it to a single easy to read and reference list on another sheet.

This code sure seems to do exactly that for me.

To be clear, if the code was to be run on another sheet with a different "map" of the solar panels, I would need to adjust the column ranges to match where the "two row" blocks occur. Correct?

Thanks Claus.

Howard