I am testing the result of many automatic report from a database that are outputted as tables on excel sheets.
in order to have quicker response the data sent from the db is raw and calculated by formulae on the excel sheet once recovered.
I need now to compare the results of said formulae with another report, and I wanted to do it by copying two similar reports results into yet another excel cartel and comparing some cells.
Ex:
A B C D E F G
1 | Avg | | | | | | Avg1 | | Test |
2 | 2.5 | | | | | | 2.51 | | =A2=G2 |
Where A is the column of the first report and G is the column of the second report.
The problem is that Avg
is a calculated cell too, so I can't copy the value onto another sheet.
As you can see I want the data on the same sheet for quicker reading and testing, so I would like to know if there's a way to "print" an excel sheet statically onto another sheet, so that the calculated cells would not be the result of a calculation but a simple value