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".