I like to use changing values of a worksheet into another worksheet with Excel for Android. Does somebody know whether this is a possibility?

Hello Wagter,

You can transfer changing values from one worksheet to another in Excel for Android! You can use formulas like = to reference cells from another worksheet or use functions like INDIRECT for dynamic referencing. Here are a few methods:

1. Using Cell References: In the target worksheet, type =Sheet1!A1 (replace Sheet1 with the actual sheet name and A1 with the cell you want to reference). This will dynamically update when the source cell changes.
2. Paste Link Feature: Copy the data from the source worksheet, go to the target worksheet, and use Paste Special > Paste Link to maintain a live connection.
3. Using the INDIRECT Function: If you need dynamic referencing, use =INDIRECT("Sheet1!A1"). This allows flexibility in referencing cells based on changing conditions.
4. Using Drop-Down Lists: You can create a drop-down list in the target sheet that pulls data from the source sheet dynamically.

For a detailed guide, check out Microsoft's support page .

Best Regards

David_Johny || Microsoft Community Moderator

Hello David Johny,

Many thanks for your fast reply, however, I fail to succeed with your first advice: using cell references. I tried to get in the target sheet: =♧2025!H20.

Something wrong with this formula?

Kind regards,

Walter

Hello Walter,

If your sheet name includes spaces or special characters, you’ll need to enclose it in single quotes. Check your sheet name carefully and try adjusting the formula accordingly.