I have attached my workflow as its easier, would like to seek guidance on two issues:
- Currently encountering the ‘object reference not set to an instance of an object’ error within my ‘for each row’ of transposing activity(transposing so that i can find a match between two workbooks thereafter).
- For looping of each excel sheet activity, would it be possible to always skip the first sheet in every workbook? Or alternatively, implementing a wildcard so that the activity only goes through all sheets that begin with a ‘C’? If so how do I go about doing that!
fyi; For my automation logic, I’m currently finding a match between a single excel sheet and a workbook, based on that condition I paste the matching information into the combined workbook.
Am a beginner and started Studio last week therefore apologies in advance for multiple questions, thanks!
Testing.zip (27.5 KB)