HI All
new to this macro thing, got a quite simple request hopefully all i need the macro to do is check the last column has true inside it and move back to the next line down and back 2 spaces.
i found the moving part of the code.
Selection.Offset(0, -2).Select
Selection.Offset(1, 0).Select
Need help with the checking the last column. I have added the simple sum of =B4=C4 to the last column.
It is for checking the two serial numbers match. some help would be much appreciated.
new to this macro thing, got a quite simple request hopefully all i need the macro to do is check the last column has true inside it and move back to the next line down and back 2 spaces.
i found the moving part of the code.
Selection.Offset(0, -2).Select
Selection.Offset(1, 0).Select
Need help with the checking the last column. I have added the simple sum of =B4=C4 to the last column.
It is for checking the two serial numbers match. some help would be much appreciated.