Need help with a vb script to import .xls data
Data I need to import is in columns C, F, H , I...First record is always in row 8.
I would like to import the data and put in on a new worksheet as such:
Column A should be Column C data
Column B should be Column F data
Column C should be Column H data
Column D should be Column I data
I would like to use a button to browse for the saved file and then import it to the new ws.
Data I need to import is in columns C, F, H , I...First record is always in row 8.
I would like to import the data and put in on a new worksheet as such:
Column A should be Column C data
Column B should be Column F data
Column C should be Column H data
Column D should be Column I data
I would like to use a button to browse for the saved file and then import it to the new ws.