Ask Your Question

Revision history [back]

Reference cell on different sheet dynamically..

I.e.

Sheet 1 cell e4 has value 18

I want then current cell to have the value from cell h18 from sheet 2

Something like (sheet2:h{sheet1:e4})

Thanks