'wsIn.Range("A" & i & ":G" & i).Copy wsOut.Cells(lrowOut, 1) Sub Solution_For_Loop()ĭim wsIn As Worksheet, wsOut As Worksheet If it is, we will copy/ cut data from the entire row and paste it into the next available row in the sheet Out. We will use an If statement to check whether the current cell value in Col G is greater than 0. We don’t want to cut the rows in which these cells exist.All other rows of data will be pasted into the worksheet called Out. As per our condition, we will check for cells with value greater than zero in the last column. The worksheet with our data is called In. The condition in this example, is that the cell value in the column must be greater than zero. This tutorial will cover how to copy or cut entire row of data and paste it into another sheet based on a condition.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |