View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
christian christian is offline
external usenet poster
 
Posts: 2
Default 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