Run Macro Based On Values In Column

  • I see that for this example this works fine and is the best solution. I am still wondering why it's not possible to let a macro run based on the import results.

  • It works for the first cell , i go's to the cell below. But then you need to click the button to import the result again. That should be nice if it run's without clicking again to add the result.


    If you put the cursur in cell A1 and then click the Run Column button it imports the value to the Main sheet. It go's on cell down. Then you need to click again to add that value to Main sheet.


  • The code that I gave you will loop through the cells until it reaches an empty cell.


    I've looked at your last workbook and this code runs fine


    Your unused code needs deleting