Forum Discussion

Belle2218's avatar
Belle2218
Copper Contributor
Jun 24, 2025

How to link data from one worksheet to another in a workbook?

Hi,
I am wanting to find a way to how to format my file such that my excel sheets are interlink in a workbook.
Sheet "Semester base dates - Column B = Column A", if on sheet "Tuition pattern" - Column I reflects sheet "Semester base date - Column B" eg sheet "Tuition Pattern - cell I15 = 11" it should link to sheet "Semester base date" - cell A41 "Because it is Semester 2 (cell B1);  week 11 (I15)" on tuition pattern sheet - this should be automatically reflected on sheet "tuition pattern" column J (Cell J15) (42) Because sheet "semester based dates Cell A46" = 42

What I want to do is when I fill my data for column I - I want to find the corresponding week for automatic filling of column J - can I do that?

*won't allow me to copy and paste my excel table to show example
 
BI & Data Analysis
Charting
community
copilot in excel
excel
power bi

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor
    Jun 26, 2025

    Here's a YouTube video that explains how to create links between sheets in a workbook. 

    If you still need help, you need to either (or, ideally, both) 

    • provide a clearer description of your situation
    • drag and drop the actual workbook toward the bottom of your next post here; don't try to copy and paste; just drag and drop

Resources