What approach should I adopt .....

[Gotroots]

Hi

I would like to ask your advise on the best approach for analysing multiple
spreadsheet.

Allow me to explain. There are ten sheets with data in A:A which is the
result of a formula. All the data in A:A in all sheets must have the same
data.
What is the best way to compare the sheets to see what data may be missing
so it can be updated for a given sheet.

Hope I have explained what I am looking to do clearly enough.

Thank you!

 

[Gotroots]

The solution you guys provide is a simple one. I think I was trying to make
it more complicated than what is needed.

Thanks for the clarity.

 

[Pete_UK]

You're welcome - glad to be of help.

Pete

The solution you guys provide is a simple one.  I think I was trying tomake
it more complicated than what is needed.

Thanks for the clarity.








- Show quoted text -