To All:

Hi all, I have been working on this task in Excel for my company project and I need more guidance. I have one source worksheet that consist of a list items. Within the same workbook, I created three dependent worksheets and each worksheet consists of data linked from the source worksheet. In this case, the same item from the source worksheet may be linked to more than one dependent worksheets. Under normal operation, if I change a value in the source worksheet, excel updates it to the rest of the dependent worksheets.

My question is, how to modify a value in an dependent worksheet, and have that new value reflect back to the source worksheet? (sort of a syncing problem between linked worksheets)

If possible, how to change a value in 1. dependent worksheet number one, and update that value to 2. the source worksheet, and then updates the same value from the source worksheet to 3. dependent worksheet number two, and number three?