Excel VBA Macro

[boilerup]

Please provide a macro that will do this...

If Cell A2 is "Yes", copy values from cell B2 into "Data" tab cell A1 and refresh Smartview pull (I don't need to sign into Smartview).
If Cell A2 is "No", move vertically down to next cell, in this case would be Cell A3 and repeat.

Keep moving down vertically in column A with this logic. Function will end if there is no value in final cell of Column A (cell 12 has no value which would end the Macro).

 

[mse330]

Try below code but I am not sure about "Smartview" ...

Sub test()

With Sheets("Setup")
    For x = 2 To .Cells(Rows.Count, 1).End(3).Row
        If .Cells(x, 1) = "Yes" Then
            ['data'!a1] = .Cells(x, 2).Value
            ThisWorkbook.RefreshAll
        End If
    Next
End With

End Sub