Moving bad rows to another sheet

  • Thread starter Thread starter Rob H
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

moving rows to another sheet 3
copy rows from one Data sheet to another sheet based on cell conte 2
Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
formula for moving information from one sheet to another sheet 5
How to move rows from one sheet to another sheet (macro) 1
Moving specific Row to another sheet. 3
Automatically Move Entire Row to Different worksheet 6

Back
Top