Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel