samedi 12 novembre 2016

Excel If cell is not blank, copy row into sheet2

I was trying to figure out how to have excel look at a cell in my workbook, if the cell has a value greater than 0 then copy that row into sheet2. It then looks at the next cell in the column.

Does anyone know??

I need it looking at cell I10 to start off and if I10>0 copy data from A10:K10 to sheet2 else look at I11 and repeat, then I12... until all 750+ rows are either copied or not.

Thanks so much for all the help!!!

Aucun commentaire:

Enregistrer un commentaire