Nel post
*natelr* ha scritto:

=Sheet1!A10

how can I change this so the "10" is determined by data in another
cell.

So, say in some cell I entered "11" the formula would change to
=Sheet1!A11

Thanks!


=INDIRECT("Sheet1!A"&B2)

where you can put in B2 10, 11 and so on.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy