Hey all,
I'm more wondering the best method (or in your opinion, the best way) to do this as opposed to a how to.
I have made a pretty sizeable database (lets call it WB1) and I can export specific info out to other workbooks (Lets say WB2). I have ~45 different templates built in WB1, and depending on a certain row value, it copies a specific template and moves it to a designated file.
All templates in WB1 have XLookup formulas to find all info I need from the WB1 database, which works fine. Once I move the sheet from WB1 to WB2, as expected it creates a reference back to WB1.
Would a good option be to Break Links in WB2 so I'm just left with the value? I know this is possible to do in VBA and I could just tuck it in at the end of my macro. Is there a way to build my XLookup function with INDIRECT so that it does not pull the WB1 reference, and I could just have the info I need in WB1 copy over to a sheet in WB2 that the XLookup/Indirect formula references?
I'm more wondering the best method (or in your opinion, the best way) to do this as opposed to a how to.
I have made a pretty sizeable database (lets call it WB1) and I can export specific info out to other workbooks (Lets say WB2). I have ~45 different templates built in WB1, and depending on a certain row value, it copies a specific template and moves it to a designated file.
All templates in WB1 have XLookup formulas to find all info I need from the WB1 database, which works fine. Once I move the sheet from WB1 to WB2, as expected it creates a reference back to WB1.
Would a good option be to Break Links in WB2 so I'm just left with the value? I know this is possible to do in VBA and I could just tuck it in at the end of my macro. Is there a way to build my XLookup function with INDIRECT so that it does not pull the WB1 reference, and I could just have the info I need in WB1 copy over to a sheet in WB2 that the XLookup/Indirect formula references?