Tag Archives: countif all sheets

Count if number is on any other sheet

With ActiveSheet lastrow = .Cells(.Rows.Count, “A”).End(xlUp).Row End With OTP = 2 For n = 1 To lastrow srce = ActiveSheet.Range(“A” & n) For x = 1 To 25 If srce = Worksheets(“Control”).Range(“A” & x) Then nme1 = ActiveSheet.Cells(n, Worksheets(“Control”).Range(“B” & x)) nme2 = ActiveSheet.Cells(n, Worksheets(“Control”).Range(“C” & x)) add1 = ActiveSheet.Cells(n, Worksheets(“Control”).Range(“D” & x)) add2 = […]

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group