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:

Item	Name	Sale Price
00821463	Super Rave	$10.00
00812028	Pink Suds
00824031	Supersan	$150.00
00132486	PF-2	$50.00

<tbody>
</tbody>

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:

Item	Name	Sale Price
00821463	Super Rave	$10.00
00824031	Supersan	$150.00
00132486	PF-2	$50.00

<tbody>
</tbody>

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!