Conditional Copying of cells
Posted by Rob on July 27, 2001 2:42 PM
Hi everyone again :) I was looking for a way to have 2 worksheets in a workbook, and have a few colums/rows of information... What I want to happen is for certain rows in the first sheet (based on a condition in one of the columns) to copy to the next page, but to the next availible cell. So, for example, if i have a colunm in the first sheet called "PAID", and some rows have "X" in them and some dont. On the second sheet, I want all the rows from the first page to copy over that do not have an "X" in the "PAID" column, but I'd like them to be together and not separated by blank cells.
Again, I appreciate any help, you guys are great! thanks.