Log In
Register
Home
October 28, 2024
Offline
Hi,
Here is my scenario:
I'm a farmer, and I have a file with my various plots (as numbers) and their respective area.
I would like to use the area of the plots for calculations in various excel files.
Some files are used for on-the-go calculations, meaning I want to get the area for the plot number I'm currently working on, so Power-query merge will not work for those files.
It makes sense to me that those requirements, given that I articulated them clearly, can be achieved in excel without the need to copy the plots list-of-values to every file.
Regards,
Ayal Telem.
October 28, 2024
Offline
Replying to myself:
The only way it can be done is creating a sheet in each workbook that looks at the list-of-values workbook.
Half elegant.
Still looking for a full elegant solution
Regards,
Ayal Telem.
July 16, 2010
Offline
Hi Ayal,
I'm not sure what you mean by 'plots', nor how your data is laid out. Can you please provide an example file that shows the data, and your desired result?
Mynda
Trusted Members
October 17, 2018
Offline
Aside of a sample file I suggest you also mention the Excel version you're using
October 28, 2024
Offline
Hi Mynda and Hans,
- Plots are agricultural sections or areas where you grow stuff.
- My Excel version is 365.
- I have attached 2 files: "Dusting Calc" & "Plots List - EN" (the 3rd file was loaded by mistake and I couldn't find how to delete it...).
- In "Dusting Calc" file, column G in sheet "Dusting" takes its FILTER values from the sheet "Plots" in the same file.
- I want to be able to take thouse values from the file "Plots List - EN" instead.
I hopen I was cleared this time.
Thanks for the efforts,
Ayal Telem.
July 16, 2010
Offline
Hi Ayal,
Thanks for clarifying. I don't recommend links to external workbooks. Instead, use Power Query to bring the Plots List data into the Dusting Calc file and reference it from there.
Most Excel formulas do not work when the workbook they are linked to is closed, so you'd have to open both files anyway. It's far more robust to simply connect to the Plots List with Power Query and set it to refresh on opening the file.
Mynda
1 Guest(s)
