How do I access the contents of a cell in another worksheet

John Eisele 0 Reputation points
2023-01-13T00:18:26.34+00:00

As I update Income projections in one worksheet (e.g."income"), I want those updates to be reflected (updated) in a second worksheet (e.g."Budget").

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
79 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 21,851 Reputation points Microsoft Employee
    2023-01-13T01:50:39.35+00:00

    Hi @John Eisele

    Can you show us a simple sample to show more details?

    Generally, you can use formulas to search data. Such as Vlookup function.

    Any issues or misunderstandings, you can let me know.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.