Copy & Paste specific cell in VBA if cell contains any number will not copy and paste if blank.

[wolverine21]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Value[/TD]
[TD]Copy and paste cells[/TD]
[TD]notes[/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]Since this has a number it will copy and paste[/TD]
[TD][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF($H7<J$5,$I7,0) example of formula I'm copying and pasting[/FONT]
[/TD]
[/TR]
[TR]
[TD]Cell is blank[/TD]
[TD]since this is blank it will do nothing[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]210[/TD]
[TD]

Since this has a number it will copy and paste​

[/TD]
[TD]<strike></strike>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]I have approx. 200 rows in the spreadsheet.

---

[/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to attach a copy of the file and or picture but I don't have a URL.
Any help would be really appreciated. I could send an example file if that would help.

 

[wolverine21]

The formula didn't copy over in the notes column.

=IF($H7< j$5,$i7,0)

 

[DanteAmor]

If we use the < o > signs, you must put a space before and after each sign, otherwise the forum editor considers it a code and then deletes the row.

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

​To give examples, check the following:
https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html