Search results

I've manage to resolve my issue by using the following code: Sub testv2() x = Sheets("Sheet2").Range("I" & Rows.Count).End(xlUp).Row For Each cell In Sheets("Sheet2").Range("I1:I" & x) If cell = 1 Then y = WorksheetFunction.CountA(Sheets("Sheet1").Columns(1)) Rows(cell.Row).Copy...

Thanks for the input. I thought about doing that, it's fairly simple to add another routine to remove them but I wanted to add something into what I already have to remove then in one step so to speak!

Hi Guys, The following code is what I use to copy rows from my excel report depending on the outcome of a particular colum to another sheet. However what I would like to know is instead of just copying the rows over, I want to move the rows completly out of the "Main" Sheet to the specified...