copying multiple row to a new sheet
I tried using the code with this line
rng1.Copy Destination:=Worksheets("Sheet2").Range("B2"
but it still doesn't do what I need it to do. I'm really stuck on this. For the rows that are true, I need to move part of that row over to another sheet, and I've gotten it to the point where it moves the first row over, but then every other true in that column will not move over. If anybody has any other suggestions it would be greatly appreciated.
|