If a cell contains #N/A then copy cell to the left and paste into the next empty cell

Hi guys, I could do with some help with VBA Code

I have a excel file in which data gets inputted, and then based on this data excel will match some text in the cell to the right from a mapping tab. If excel can't find a match for this data, I get an #N/A error. So I want to search column V and If I get this error, I want to copy the data in the cell to the left of the #N/A error (Column U) and paste it into the first empty cell in column A of another tab.

So basically, I want to search column V for #N/A Errors, if there is an error, copy the cell to the left of the #n/a error and paste it into the first empty row of another tab.

Thanks guys, hugely appreciated!

Originally Posted by jimmymac91

Hi guys, I could do with some help with VBA Code

I have a excel file in which data gets inputted, and then based on this data excel will match some text in the cell to the right from a mapping tab. If excel can't find a match for this data, I get an #N/A error. So I want to search column V and If I get this error, I want to copy the data in the cell to the left of the #N/A error (Column U) and paste it into the first empty cell in column A of another tab.

So basically, I want to search column V for #N/A Errors, if there is an error, copy the cell to the left of the #n/a error and paste it into the first empty row of another tab.

Thanks guys, hugely appreciated!

Hi,

Please Login or Register  to view this content.

It is hard to guess what exactly youre looking for?
Does this solve the problem?

KindRegards
KRand

Thanks, but I get a runtime error '13'

Type Mismatch

?

Also, will this only look in Column V, or will it search the whole sheet? Need it to just search column V. How do I change the code to accommodate that?