AnsweredAssumed Answered

Can I automatically import just a cell or 2 from an Excel spreadsheet?

Question asked by SteveMartino on Jun 18, 2013
Latest reply on Jun 20, 2013 by SteveMartino

Title

Can I automatically import just a cell or 2 from an Excel spreadsheet?

Post

     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.

     Thanks

     Steve

Outcomes