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

Hi, Sam,

maybe this may give you a hint:

Please Login or Register  to view this content.

Cioa,
Holger

I think that may get me close, can you tell me if what I came up with is workable?

on the line that contains "If Activecell.Value = "N/A" Then" it kicks out a mismatch error

Please Login or Register  to view this content.

Hi, brgr4u,

what does not available mean for Excel? An error occurred - maybe thatīs why I used IsError.

And there is hardly one good reason to select each and every cell to work with ActiveCell (except a lot of unnecessary cursor movement and the macro recorder displaying code like that with Selection).

Ciao,
Holger

Hi, brgr4u,

do you have any formulas that you want to copy? I generally try to put values into the backup sheet as the data may show different results from what they showed on the original sheet.

Please Login or Register  to view this content.

Ciao,
Holger