VBA copy filtered result to next column help. New to VBA

[kc001]

Hi, I need a macro that allows me to filter on any blanks and ‘0’ on column G, and then copy whatever data [there can be none, or blank rows in between] on column F to column G for each row that contains blanks or ‘0’. I am new to Macro and programming and here are what I have so far:

Please Login or Register  to view this content.

The problem I believe I am running into is that if there are spaces in column F or G; this macro is does not work.
Please help.

Moderators note: code tags added for you - this time

[FDibbins]

Hi and welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here