R
Rob H
Hi,
I need to move any rows containing empty fields or null or #err etc to a
separate sheet named error. The column widths are the same and the column
headers are the same.
It seems to me as if I need to go along the lines of identifying the rows
one by one, cutting the row then moving records up. Pasting in the row then
making sure the next one is only pasted into a row with all spaces empty.
I really dont know where to start with this so even a pointer would be a
great help!
Many Thanks
Rob
I need to move any rows containing empty fields or null or #err etc to a
separate sheet named error. The column widths are the same and the column
headers are the same.
It seems to me as if I need to go along the lines of identifying the rows
one by one, cutting the row then moving records up. Pasting in the row then
making sure the next one is only pasted into a row with all spaces empty.
I really dont know where to start with this so even a pointer would be a
great help!
Many Thanks
Rob