temp.zip (16.4 KB)
Q1. What I want to do is I saved c1:c30 as dt1 in the read range above, but I don’t know how to write it by going to column “b” after collecting data, so I’m using “B”+(Counter+1).ToString.
How can I move from the column I’m working on to the “B” ROW without using this method?
I’m filling in the data through the counter in column B as a really simple solution. OMG…
Q2. Also, if there is no data in column C after writing C1:C999 in the read range, I would like to skip to the next row.
Ex) “C1 = EMAIL” → “C2 = NULL” → SKIP → “C3 = EMAIL”
This is also very simple. If there is no data collected from FOREACH, I use the IF statement to process item.ToString = “” == “”.