Merge Workbook into another workbook as a live copy

Question

I am trying to merge a workbook (A) into a another workbook (B) but keeping the original and having the copy (B) be a live copy so when data is entered into (A) the changes or updates will show in (B)?

I was able to copy the sheet but I entered data and its not transferring live. I am new to all of this so I appreciate your help!

hansvogelaar · Answer

Nicole85&nbsp;
You can copy a range, then paste it as a link into another sheet.

nicole85 · Answer

HansVogelaar&nbsp;- Thank you I will try this. This will keep the formatting &amp; formulas from the original document, is that correct?

hansvogelaar · Answer

Nicole85&nbsp;
Yes, it should.

nicole85 · Answer

HansVogelaar - I got it to work the way you suggested but when I edit the original file (A) its not transferring the information to the other worksheet (B). Let me know if you know how I can do this?

hansvogelaar · Answer

Nicole85&nbsp;
Are you sure you selected Paste Link?
If so, you should see formulas in the target range that point to the source range.

Forum Discussion

Merge Workbook into another workbook as a live copy

Share

Resources