In transfer spreadsheet macro action how can we put the range of column only as A1:A20 with unlimited rows .
In transfer spreadsheet macro action how can we put the range of column only as A1:A20 with unlimited rows .
you would attach the workbooks as an external table.
an append query would allow you to use only 1 field. (column)
you can either have premade queries , 1 for each column (if theres not that many)
or
make the query virutally on a form...user picks the column,click button to import...
select " & cboBox & " from table