Excel Loop and store Variables

Learning Hub Academy Feedback
, ,
1

Hi,

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.

image

Help is much appreciated.

Cheers

2

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
3

Thanks ! it works like magic

4

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