Forum Discussion
Create a link between two Excel files
Trying to figure out how to resolve your situation with only a verbal description is well nigh impossible. I know your actual files contain real names and other identifiable information so they can't be shared. However, you'd be helping us help you if you could create a mockup of the real spreadsheets, using false names, and post those on OneDrive or GoogleDrive with a link pasted here that grants access.
Also let us know what version of Excel you're working with, or if you have a Microsoft 365 subscription. There are newer capabilities in that subscription or in the newest version of Excel, capabilities that might enable you to achieve the desired result without a macro. But, as noted, all of that would be easier to determine if you could post mockup samples of the actual workbooks.
- We have an Office 365 subscription I believe
Wow! That may be more than I can handle, but perhaps somebody else in this forum will be able to take a look at those two sheets.
In examining them quickly--unfortunately I have a major engagement today that will preclude spending more time--I did notice that the formulas in the "template declaraties automatics" spreadsheet are looking for data in "data_volunteers.xlsm" but the sheet I downloaded is "data_volunteers1.xlsm" If that's also what you're working with then that could explain why no data is being found: it's looking for a data sheet by a different name. So check that name and change it, if that's the case.
Beyond that, I need to invite others to take a look for now.
- hey! Thanks for your quick response. I just created a new file based on the data_volunteers one so I could delete the data and upload to OneDrive. The file is actually called data_volunteers when I'm working with it so that's not the problem!
- https://1drv.ms/x/s!AlufqoyaYmiWkE_mQC5hzUNmAGFr?e=e1a6Dp
https://1drv.ms/x/s!AlufqoyaYmiWkFL8zPuyRAmFpLcj?e=0EDNxl
