Forum Discussion
karol polubinski
May 17, 2018Brass Contributor
Transfering from 2 work books from multiple sheets and updates itself
Good Evening Gentlemen, I and doing two work book I need that the information from multiple work sheets gets transferred and updated into the second work book. I have been using = and enter, ...
Matt Mickle
May 21, 2018Bronze Contributor
Karol-
Try looking at this post. It references another way to go about what you're doing that may work better depending on your particular scenario:
https://techcommunity.microsoft.com/t5/Excel/Adding-information-to-different-sheets/td-p/194438
The workbook should update using your current method too though. Have you tried going to:
1. Data Tab
2. Connections
3. Then Selecting the link and refreshing it
or
1. Data Tab
2. Refresh All
I'm attaching the workbook with data connections to this post as well for easy reference. It uses links to the source data in order to get different "views" without modifying the source data.