Create report from the table by the format of the cells

[herclau]

OK, I'll add a count column too. But do you want all the other columns (C:AM, AO:CO) to be candidates for possible inclusion in the results?

It is not necessary to include other columns (C: AM; AO: CO). The content of these will be included in the report if they differ with the content of the row where the failure is reported.

 

[herclau]

There seem to be two tables on that second sheet (Faults found). Am I right that it's the table at cell A1 plus the column differences of all the other columns in the source data?

 

[p45cal]

You've completely and utterly lost me.

 

[vletm]

herclau
Is there still missing something from mine sample?
Except that 'Grand Max'? ... which word is not in Your the latest data... hmm?
... and from which data would above snapshot?

 

[herclau]

herclau
Is there still missing something from mine sample?
Except that 'Grand Max'? ... which word is not in Your the latest data... hmm?
... and from which data would above snapshot?

The instantaneous one is from the file:

 

[vletm]

herclau
Three questions - none answers.

 

[herclau]

herclau
Three questions - none answers.

Is there still something missing from my sample?
R:
The last Macro Do_it () is the one that ran in the attached file (# 55) ML33AB.xlsb. Is there a new update?

Except that 'Grand Max'? ... What word is not in your latest data ... hmm?
R: With 'Grand Max' we finalize the report

... and what data about the snapshot?
R: The instantaneous data is (# 55)

My apologies for the inconveniences that my answers have caused!
But very grateful for the perseverance of helping you show !!!!!!!

 

[vletm]

My 'Your names' marco do not give those results!
My 'code' gives to left side results (which don't include within original 'hope') have different 'Time's
and the last row is totally different!

Without Your clear facts ... I don't know do You need update?

 

[herclau]

My 'Your names' marco do not give those results!
My 'code' gives to left side results (which don't include within original 'hope') have different 'Time's
and the last row is totally different!
View attachment 61500
Without Your clear facts ... I don't know do You need update?

I'm going to check. I will work on the ML33AB.xlsb
Is it about that you executed your code?

 

[vletm]

herclau
I'm using my code, which I have here.
I don't check or compare with any other codes.