I have this simple formula:
=comida!B6

what i need is to have the content of a Cell that could change the sheet name,

Example Cell a1 in sheet1 change from Comida to Comida2, this updating the
sheet name link.

Can tis be dolne?

How about:
=INDIRECT("'"&A1&"'!b6")




MESTRELLA29 wrote:

I have this simple formula:
=comida!B6

what i need is to have the content of a Cell that could change the sheet name,

Example Cell a1 in sheet1 change from Comida to Comida2, this updating the
sheet name link.

Can tis be dolne?

--

Dave Peterson