Forum Discussion

Nicole85's avatar
Nicole85
Copper Contributor
Jan 19, 2023

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)?

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!


    • Nicole85's avatar
      Nicole85
      Copper Contributor

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

      • Nicole85's avatar
        Nicole85
        Copper Contributor
        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?

Resources