VBA create table from existing table selecting rows based on values

[NiccoExcel]

I need to create a new table in excel on the existing sheet "ScratchPad" by pulling rows from the existing table named "ChemItems" but I only want to pull the rows if a value is populated in the column "Sale Price". Here is an example of the ChemItems table:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Name[/TD]
[TD]Sale Price[/TD]
[/TR]
[TR]
[TD]00821463[/TD]
[TD]Super Rave[/TD]
[TD]$10.00[/TD]
[/TR]
[TR]
[TD]00812028[/TD]
[TD]Pink Suds[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00824031[/TD]
[TD]Supersan[/TD]
[TD]$150.00[/TD]
[/TR]
[TR]
[TD]00132486[/TD]
[TD]PF-2[/TD]
[TD]$50.00[/TD]
[/TR]
</tbody>[/TABLE]

There are other existing columns on the table, but as far as I know they are irrelevant to the program I want to create. If I were to run the program successfully it would result in a new table on the sheet "ScratchPad" that would look like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Name[/TD]
[TD]Sale Price[/TD]
[/TR]
[TR]
[TD]00821463[/TD]
[TD]Super Rave[/TD]
[TD]$10.00[/TD]
[/TR]
[TR]
[TD]00824031[/TD]
[TD]Supersan[/TD]
[TD]$150.00[/TD]
[/TR]
[TR]
[TD]00132486[/TD]
[TD]PF-2[/TD]
[TD]$50.00[/TD]
[/TR]
</tbody>[/TABLE]

Note that the "Pink Suds" item was removed because there was no value in the sale price.

I think I need to create a FOR NEXT program but I am not really sure where to begin. Please Help!