Hi guys,
I am new to VBA coding and trying to learn how to copy values in a column into another sheet but only until a blank cell is reached even if there is a formula with and iferror then blank ("") is in it.
I believe for loops are perfect for this and something such as "if cell > 0" then... can be utilized to keep copying until a blank cell with formula in it is reached.
So far I understand that something like x = x+1 in the loop can be used to loop through a range but I couldn't resolve to actually copying and pasting it in a new worksheet.
I am attaching a sample workbook for you to maybe understand what I mean more clearly.
Much appreciated!
Bookmarks