1 Attachment(s)
Linking of Excel sheets and updating the data from one sheet to all the sheets
Hi guys!
I have a problem. I want all of your help in solving the problem. For the purpose, I have created a sample sheet and enclosed:
The sample sheet contains four worksheets in it.
The first worksheet titled “schools performance” is the master sheet and all the next three work sheets (sub sheets) were created out of the master sheet.
Now the requirement is
1) I want to link all the worksheets and
2) as I start updating the data in the master sheet( school performance), I want the data to get updated simultaneously in all the other three sub-sheets.
Note: Please also guide whether the solution you provide would work only if all the sheets( sub sheets) are arranged within the same excel sheet ( as arranged in the sample sheet) or otherwise even if the sub sheets are placed as individual excel sheets(separate sheets)
Thanking you
Varadhu