How can I copy a row as result of an IF function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a group of cells be copied to another sheet when a cell
returns a certain text message. IE - if cell d25 shows" out of range", then
copy cells a25:c25 to another sheet?

I think I need something like an exception report. When the worksheet is
opened it gathers data and then displays when it is out of range. I need to
get only the rows that are out of range to appear in a different sheet so I
don't have to scroll thru a bunch of rows to fine any that went out of range.

I hope this has made sense...THX
 
Why not use the Autofilter to simply filter on the 'Out of Range' message in
col D?
HTH,
 
Sometimes the obvious is what I miss....I think that a variation of this will
work. thx
 
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

VBA Autohide Help 6
copy rows to another file 3
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
How do I copy a range of data to another sheet? 2
Copy data that matches criteria in one worksheet to another worksh 1
Set non-continuous PrintArea via Function / Name 0
Delete rows based on contents of Col A 0
Using functions for a cell with a number-range 3

Back
Top