AnsweredAssumed Answered

Data card variables used to update excel cells.

Question asked by Jeff Thomas on Sep 4, 2013
Latest reply on Sep 4, 2013 by 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.