You just have to link them.
Dec 17 2013 02:50 PM
For example you want to show the values in cell A4 in sheet Test1 into cell B4 in sheet Test 2. Just go to cell B4 and type "=" then go to Test1 and click on A4.
The value will be visible in B4 now.