J
Joseph Anthony James
To All:
Happy Holidays, I have been working on this task in Excel for my school project. I have one master worksheet that consist of a list of 100 items. Within the same workbook, I created 5 more worksheets and each worksheet consists of data linked from the master worksheet. The same item from the master worksheet may be linked to more than one worksheets. The troubling part is,when I change a value in the master worksheet, it reflects on the rest of the workbooks.
My question is, how to change a value in an individual linked worksheet, and have that value reflect back to the master worksheet, and then reflect the same value further to the rest of the worksheet, which links to the master sheet?
Thank you for your attention and happy holidays.
Happy Holidays, I have been working on this task in Excel for my school project. I have one master worksheet that consist of a list of 100 items. Within the same workbook, I created 5 more worksheets and each worksheet consists of data linked from the master worksheet. The same item from the master worksheet may be linked to more than one worksheets. The troubling part is,when I change a value in the master worksheet, it reflects on the rest of the workbooks.
My question is, how to change a value in an individual linked worksheet, and have that value reflect back to the master worksheet, and then reflect the same value further to the rest of the worksheet, which links to the master sheet?
Thank you for your attention and happy holidays.