How to bring values from other a worksheet within a same workbook?

I need to map values in a call in a worksheet to another cell in another worksheet in same cell. How do i do it?

1 Answer(s)


You just have to link them.

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.