Can I automatically import just a cell or 2 from an Excel spreadsheet?
Hello forum. I was wondering if it is possible to automatically import just 2 cells from an Excel Spreadsheet onto a layout. The basic reason is I use a spreadsheet to store historical weather data (hi's low's, avg, etc.), and it's quite large. After it does all the calculations I need, I just need 2 of the results (2 different cells), to land on a layout. These 2 numbers are then used in a script to calculate deliveries.
The way I do it now, is to just copy the 2 fields, then insert them into a container field, then manually enter the 2 numbers into the fields that need them to run the script.
Didn't know if I could automate the process.