Forum Discussion
Merge Workbook into another workbook as a live copy
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...
HansVogelaar - Thank you I will try this. This will keep the formatting & formulas from the original document, is that correct?
Yes, it should.
- 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?
Are you sure you selected Paste Link?
If so, you should see formulas in the target range that point to the source range.
