Using read range with while loops

Help StudioX
,
1

Hi everyone,

My issue is this: I am trying to copy the values in an excel sheet that are spread across 3 tabs (sheet 1, sheet 2, sheet 3) into a datatable. I would ideally like for it to be part of a while loop, so that I can repeat the read range and add data row activities without copying and pasting them over and over again. However, as far as I can tell, the read range function requires the user to input exactly which sheet they would want to read. Therefore I was wondering if it was possible to use only one read range activity in a while loop if there were 3 sheets to read. Thanks in advance for any replies!

2

Can you give some exampler sheets so that, we can get more clear picture on your issue? @Fishman9837