copy many rios data from parent sheet to opthers 10 sheets keeping link to teh parent sheet

Chaturvedi, Santosh 430 Reputation points
2026-09-18T15:12:38.3766667+00:00

Hello

I want to copy the the series of rows (from row 1 to row 50) to other 10 sheets keeping link to the parent sheet in same workbook.

If i change the parent sheet data the all the other 10 sheets shall also to be changed. how to do this

Microsoft 365 and Office | Excel | For home | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 933.9K Reputation points Independent Advisor
    2026-09-18T15:48:41.6233333+00:00

    In one of the sheets you want to copy the data to, click into a cell and type an equals symbol (=).

    Then go to the sheet you want to copy the cell from and click the cell.

    Then, go back to the sheet with the copied cell and select that cell, you can then click and drag downwards to use Autofill to copy the appropriate formula for the other cells.

    Do the same for the other sheets you want to copy the data to.

    Then whenever you change the values in the parent sheet the values will also change on the other sheets.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.