Help Please.
I am trying to find one worksheet to check if cell is not empty, if data is found, would like to copy Row from bolumn B to Column M to another workbook by appending to the end.
this is what I have, the first part works but not the copy and paste to another workbook.
For i = 5 To...