Copy Cells to new spreadsheet based on Cells(i, 4) value
Very new to VBA - my apologies for such a newbie question...
* Need to read each row in a spreasheet (number of rows in the
spreadsheet will always be changing)
* if there is a value in Cells(i, 4) I want to copy columns 4,5,7,10
to a new workbook. [one or more rows makes up one record - the value
in column 4 signifies a new record]
* This new spreadsheet will be turned into a CSV to feed another
program.
How would you approach this?
Any help is appreciated!!
-christian
|