How to update data from linked worksheet back to a master worksheet?

  • Thread starter Joseph Anthony James
  • Start date
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. I have one master worksheet that consist ofa list of 100 items. Within the same workbook, I created 5 more worksheetsand 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. I understand that when I change a value in the master worksheet, it reflects on the rest of the worksheets within a workbook.

My question is, how to change a value in an individual linked worksheet, and have that new value reflect back onto the master worksheet. In addition, how to reflect the same value further to the rest of the linked worksheets including the individual linked worksheet where I put the new value in?

Thank you for your attention and happy holidays.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to update a value from a linked worksheet back to the master worksheet? 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Syncing between source worksheet and dependent worksheets 0
VBA Coding Help for Beginner 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
VBA to do a mailmerge from a Specific Excel worksheet 0

Top