- Hot Topics
Excel Copy and Paste Row to another sheet IF Column E does not equal BAS or DPO
Hello, I hope you are doing well. I have a question. I am looking for vba code that will place data from sheet 1 to sheet 2 (for example) if the value in column F equals 25411013 AND column E in the same row does not equal BAS or DPO. Sample code I have so far: LR = Cells(Rows.Count, "E").End(xlUp).Row With Range("E2:F" & LR) .AutoFilter
This question generated 17 answers. To proceed to the answers, click here.
This thread is current as of August 16, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel