J
Joseph Anthony James
To All:
Happy Holidays, I have been working on this task in Excel for my company project and I need more guidance on how to solve this problem. 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 multiple data linked from the master worksheet. The same item from the master worksheet may be linked to more than one worksheets within the same workbook. I understand that, if I change a value in the master worksheet, it will reflects onthe rest of the linked worksheets.
My question is, how to change a value in an individual linked worksheet, and have that new value reflect back onto the master worksheet. At the same time, the new value updates itself to the rest of the worksheet including the individual linked worksheet where I put the new value in.
Thank you for your attention and happy holidays.
Happy Holidays, I have been working on this task in Excel for my company project and I need more guidance on how to solve this problem. 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 multiple data linked from the master worksheet. The same item from the master worksheet may be linked to more than one worksheets within the same workbook. I understand that, if I change a value in the master worksheet, it will reflects onthe rest of the linked worksheets.
My question is, how to change a value in an individual linked worksheet, and have that new value reflect back onto the master worksheet. At the same time, the new value updates itself to the rest of the worksheet including the individual linked worksheet where I put the new value in.
Thank you for your attention and happy holidays.