Copy/Paste Adjacent Cells based on ActiveCell

Hello,

I am looking for a piece of code that will search through the data in column E and if the value in column E is #N/A, then it will copy the adjacent data in columns A-D into a new worksheet.

I have tried using Offset to select the 4 cells to the left of the activecell but I cannot select all 4 at the same time.

Any help is greatly appreciated!

Thank you!

Sam