I need to cut an entire row and paste to another sheet within the workbook if the data in a specific cell equals the data in another cell. I need a macro that will check all rows for this condition and perform the cut and paste.
Example: If C2 = C8, select row C and move to worksheet "2".
Any help with this would be appreciated.
Hi there,
your question is confusing because you are mixing rows with columns
let me try this
If 2 cells (C2 and C5) are equal, I need to move that entire row to another sheet. If D2 and D5 are equal, move this entire row of data to another sheet, and so on.
Basically, I need to select any row in which a certain condition is met and move it to another sheet.
Thanks again for any help you can give.
What row are you referring to that you want movedOriginally Posted by bpreas
Man, do I feel dumb!! I guess you really CAN go brain dead after looking at numbers too long!
I meant to say that if C2 and H2 are the same, move row 2. This needs to apply to any other row where the value in C and H are the same. And if it makes a difference, this sheet has been sub totaled using Columns O and R with "Summary below data" selected for those columns.
I apologize for the confusion. No wonder I wasn't getting replies to this.
Does this make better sense now?
Sorry again.
Last edited by bpreas; 07-20-2007 at 11:17 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks