Copy and Paste using FOR loop and IF statement

As you can imagine by the title, I'm still new to VBA. I have a tab in an excel workbook, Frontier1. The idea is that I want to copy column C, but only where column C isn't blank and column F is greater than 0. Keep in mind I've replaced the data, but column F will normally be in decimal form, for what it's worth.

I'm pasting to the Parse tab, where column J and K is the goal output.

The code itself includes some other pieces where I'm finding the correct column but as you can see, the loop appears to be the main issue.

Can someone please advise?

Please Login or Register  to view this content.

Any help appreciated!

Thanks so much for this, very much appreciate the help. A couple questions...

When I run the macro, I notice it pastes the strings "ISIN" and "Current" in the first row under "SYMBOL" and "WEIGHT" but in reality, I would need it to start with ISIN2 (since that's the first instance where Column C isn't blank and Column F >0).

Also, can you please explain the IF statement being used?

Lastly, I'm used to excel syntax and am wondering why you chose to move away from the initial piece of the loop in the original version.

Please Login or Register  to view this content.

Again, appreciate the help. Still learning...

Attached has the result I understood you were after. If not, let us know which Column you want the values in.

Everybody has their own way of doing things. A few times I ran into problems with "IsEmpty" so I stay away from it. When I was Googling for a solution at that time several suggestions were to use what I use now and in this code.
That is not written in stone though so use whatever works and is proper for the occasion.
The first code checks if there is anything in the Cells in Column C and if there is and the Column 3 to the right has a Value > 0 then The first free cells in Columns J and K in Parse sheet will get these values.
The 2nd code will check Column C only in the Cells that have something in it, not the empty cells.

I saw that you marked it solved. What was the problem? Was your attachment different from your original? Data started at a different row maybe?