NiccoExcel
New Member
- Joined
- Oct 30, 2015
- Messages
- 6
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:
<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:
<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!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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!