Hello Forum, hope y´all having a great day.
This topic is divided in two question, where any of the two can solve my problem.
First question, as the title quotes… I have a data table with lets say five columns. The first three columns have the same amount of data, but the last two does not. My goal is to be able to find the index number of the first empty row from the last two columns, so I can retrieve that index and input data right from the correct row.
I know I could achieve this result by iterating through the data table, but I´m thinking they should be a expression that can also find it.
Second question
I would like to read a range from only the columns in “E” through “G” so in my Read range activity I want to state that I want to read freely but only through this to columns letter, How can I achieve this? Maybe I know the index to start from the letter “E” like 2 but the range for G for me y dynamic and I can´t input to the range property something like this “E2 : G” as far as I know. So How could I make this specific but dynamic enough?
Thank you very much for yours attention. I´ll be waiting for response.