6 Replies Latest reply on Jun 20, 2013 9:10 AM by SteveMartino

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

    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