i like to copy all values in cells are filled from Cell E2 down in worksheet PROCESS to Worksheet EXPORT from Cell N2 down. All cells are "not filled" has a #NV with formula because of missing data. All cells are filled has a value like
an email-adress "firstname.lastname@example.org"
i've found an example but it copying if the cells are colored.
Function CountByColor(CellColor As Range, SumRange As Range)
Dim myCell As Range
Dim iCol As Integer
iCol = CellColor.Interior.ColorIndex
For Each myCell In SumRange
If myCell.Interior.ColorIndex = iCol Then
myTotal = myTotal + 1
CountByColor = myTotal
Thanks in advance for your help