mike31z
07-25-2011, 06:43 PM
I need a code to copy the values from cell A1:GJ1 (this is the header row) the bottom right. The number of rows changes numerous times daily.
The source file is names :SSco.xls, the only tab in the file is named; SSco
The destination file is named: evt11.xls the worksheet tab is names ssco already created.
The formating of the destination tab is not a issue except the header row should be bold.
Once I get the source data into a new file/workbook tab I can then sort as needed.
If i just " if(iserror(vlookup xxx" then I get unnecessary lines that causes sorting errors.
The SSco.xls file is created by a paradox file generator that the original source is called : ssco.DB
I can attach a small sample file of the ssco.xls if needed.
The source file is names :SSco.xls, the only tab in the file is named; SSco
The destination file is named: evt11.xls the worksheet tab is names ssco already created.
The formating of the destination tab is not a issue except the header row should be bold.
Once I get the source data into a new file/workbook tab I can then sort as needed.
If i just " if(iserror(vlookup xxx" then I get unnecessary lines that causes sorting errors.
The SSco.xls file is created by a paradox file generator that the original source is called : ssco.DB
I can attach a small sample file of the ssco.xls if needed.