Topic: To compare two files Excel
Help, please. Or stick with a nose where to read or search. Google gives not that.
There is a necessity to compare two files Excel. Files identical, each of them contains 47 sheets (can be more). On sheets the formatted, ready tables for the press. Tables different are small, and is that are printed on 4 sheets of format 4.
How to check up these tables? Digits should be identical
It is possible to make so: we create a similar empty file 3, in each table we write fajl1-fajl2, we copy on all sheets and we look where more than 0.
But these files will be much (the annual report in state enterprise) and time has not enough.
There is a thought to create in 3 one more sheet and in two cells to register a way to 1 and 2. And at change of a way in these cells - the data is enumerated. But I can not create the such. I interpose a hyperlink, and it further in formulas is not read.
Really such to make without using VBA?