dimanche 29 mars 2015

Excel 2007 VBA Code to Copy Row from Worksheet 1 to Worksheet 2 if single criteria met

I have a worksheet ('CSVin') containing rows of sales order data (from row 2 to row 101). If the 'quantity' column (column 'C') is greater than 0, I want to copy the whole row to another worksheet ('CSVout'), starting at row 2. Therefore, there are 100 rows of data in CSVin, but (for example) there may only be 12 rows that have a 'quantity' greater than 0, and these 12 rows need to be copied to CSVout.


Any help would be greatly appreciated.


I have looked at lots of pieces of code for this, but they don't match my need and I don't seem to be able to modify them correctly as I don't have a lot of VBA experience.


Aucun commentaire:

Enregistrer un commentaire