Excel Loop and store Variables


I am in process opening looping a datatable and stuck at ‘read range’ activities.

what i needed is to loop through each row in the data table, IF header on column D is empty then do nothing, otherwise store value HeaderD = “D” & row, HeaderE = “E” & row, HeaderF = “F” & row and HeaderG = “G” & row.


Help is much appreciated.


you may have to rename the Headers so they are unique but this will give you an idea of how to do it:

Main.xaml (8.0 KB)

Cycle through the rows, look at the second column each time. If its blank, do nothing.

If there is a value output each value in the columns.

1 Like

Thanks ! it works like magic

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.