1 Reply Latest reply on Sep 4, 2013 1:19 PM by Jeff Thomas

    Data card variables used to update excel cells.

    Jeff Thomas

      I have read through just about everything on the forum that has to do with variables and Excel files. Why Microsoft can't provide details on how to link variables in a spreadsheet is beyond me. I have finally figured out how to link the the cell to the variable on the data card however it is not how I want it to work. The Excel cell is not getting the information from the card but the card is getting information from the cell. I need to be able to fill the card out and create the new Purchase Order and have the variables show up on the spreadsheet. Here is what I have done.

       

      Named the cell on the spreadsheet "Vendor_Contact" and then LINKED the cell to the card variable "Contact".

      Excel Capture.JPG

       

      Any help with this would be great.

       

      Jeff