If a column equals "Not Paid" copy and move to another sheet?

[jennie1153]

Is there a way to copy and move an entire row in a sheet with a formula if a certain column equals "Past Due"? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Here's the deal.. I have a huge sheet of data and I have done a "IF" formula to have then marked as "Paid" or "Past Due", What I would like is that if I could make a formula to copy an entire row only if Column C says "Past Due" into a new worksheet. Is this possible?<o></o>
<o></o>
Here is an example of my spread sheet that I need certain information from.<o></o>

I hope that my question is clear enough Thank you in advance!

 

[AlphaFrog]

Cannot move a row with just a formula. You could do it with a macro, or it would be fairly easy to do it en masse manually.

• Select column C
• Select from the menu Data\Filter\Autofilter
• This will put a dropdown list in cell C1
• Select from the C1 dropdown list "Past Due"
• This will hide all the rows that are not Past Due
• Select all the visible Past Due rows and copy-paste them to the other sheet
• Select the visible Past Due rows again and delete them
• Select Autofilter again from the menu to turn it off

 

[Joe4]

Excel formulas cannot "move" anything, they can only return values in the cells that they are located in.

If you need to physically "move" data, it will probably require a macro (unless you do it manually).