Transfer Data from One Workbook to Another (SPILL Issue)
Hey! I’m working on an Excel setup where the workbook on the left is my source and the one on the right is my destination. My goal is to automatically transfer the “Given IDs” from the source to the destination based on their assigned codes. I fixed the one‑to‑many lookup issue, but now I have another problem — when I type an existing code again in the destination (highlighted in green), it shows #REF! instead of its IDs. Is there any way to fix this without losing the automatic transfer I already have?
+ A user suggested to the COUNTIF into a MOD. I'm not sure how to operate this so I hope anyone could teach me.
+ "FILTER('[book 2.xlsx]Sheet2'!B:B,ISNUMBER(XMATCH('[book 2.xlsx]Sheet2'!A:A,B:B)))" = this also helps but I also encounter the aforementioned problem
(in my real workbooks, there will be times when I need to enter the same codes directly in the destination, and I don’t want to keep going back to the source workbook to re‑enter them all over again.)
Thank you so much in advance!
[link] [comments]
Want to read more?
Check out the full article on the original site