Hi Guys,

Is there a way to select for each title field (assuming that there are 4 of them for example) a certain cell from an Excel file? I mean for example:
- TextBox1 to have the value stored in cell A1
- TextBox2 to have the value stored in cell A2
- TextBox3 to have the value stored in cell B1
- TextBox4 to have the value stored in cell B1

In this moment, if I read it right, all the update-able values should be on a single row or on a single column. I use a simple workaround and use as data source a supplementary row (e.g. row 10) where each cell value is equal with one of the cells that I need (e.g. Row10.Cell1 = A1, Row10.Cell2 = A2, Row10.Cell3 = B1, Row10.Cell4 = B2) but this becomes annoying when we talk about large tables (with multiple rows and columns).

Thank you,
Claudiu

There is an option to convert the rows to columns in the data source settings.
This will number the columns for every row, allowing you to assign individual cells to any title.

http://www.vmix.com/help19/DataSourcesSetup.html