vba if query issues

Hello,

the code below is to search column 3 for any value put into column 1. then it is meant to look in column 4 and if that is empty paste in the information but if it has data in it to insert a line then paste the data. the issue I am having is that it inserts the line regardless of whether there is information or not. can someone tell me how to fix this and explain what I did wrong so that I don't make the same mistake in the future.

Please Login or Register  to view this content.

apologies if the code is messy or inefficient, I am quite new to coding with VBA,

Not entirely clear to me if you are copying the search value or the target, but along these lines.

Please Login or Register  to view this content.

Originally Posted by BaronVonBeefDip

1. ... the code below is to search column 3 for any value put into column 1
2. ... then it is meant to look in column 4
and
3. if that is empty paste in the information
but
4. if it has data in it to insert a line then paste the data ...

I don't know if I understood correctly (maybe attach your example, i.e. layout and expected result ... ?)

Please Login or Register  to view this content.