joshua1990
08-21-2017, 12:00 AM
Hey guys!:)
I am just trying to structure my data and to collect records, which information is missing, in another table.
So far, I have copied to tblTwo with the following code, records, or rows, which did not empty the data in column A (empty).
With tblExport.UsedRange
.AutoFilter 1, ""
With .Offset(1, 0).SpecialCells(12)
.Copy tblTwo.Cells(tblTwo.Cells(Rows.Count, 2).End(xlUp).Row + 1, 1)
.Delete
End With
.AutoFilter 1
End With
However, I now have to expand the following conditions:
If column A = "" then cut and paste row after tblTwo.
If column D = "" then cut and paste row after tblTwo.
If column E, F, G or O = "" then cut and paste all rows of this class (class oriented to column D) after tblTwo.
The difficulty is that when columns E, F, G, or O are empty, these rows are transferred to tblTwo, but including the entire class.
In this case, the class / group is oriented to column D. Note, however, that this group should be located within the group of column C. Thus, there may be the same cells of the group from column D, but these belong to different classes from column C. Correspondingly, the entire class of column D is to be observed or transferred within the class of column c.
Does anyone have a meaningful approach to me or any suggestions?
I am just trying to structure my data and to collect records, which information is missing, in another table.
So far, I have copied to tblTwo with the following code, records, or rows, which did not empty the data in column A (empty).
With tblExport.UsedRange
.AutoFilter 1, ""
With .Offset(1, 0).SpecialCells(12)
.Copy tblTwo.Cells(tblTwo.Cells(Rows.Count, 2).End(xlUp).Row + 1, 1)
.Delete
End With
.AutoFilter 1
End With
However, I now have to expand the following conditions:
If column A = "" then cut and paste row after tblTwo.
If column D = "" then cut and paste row after tblTwo.
If column E, F, G or O = "" then cut and paste all rows of this class (class oriented to column D) after tblTwo.
The difficulty is that when columns E, F, G, or O are empty, these rows are transferred to tblTwo, but including the entire class.
In this case, the class / group is oriented to column D. Note, however, that this group should be located within the group of column C. Thus, there may be the same cells of the group from column D, but these belong to different classes from column C. Correspondingly, the entire class of column D is to be observed or transferred within the class of column c.
Does anyone have a meaningful approach to me or any suggestions?