I’m trying to copy the data from my datatable to my main master list spreadsheet with lots of tabs.
in my datatable, if the category is under cat A, bot to search for tab cat A. and from there, bot to find the name and fill in age, occupation and company in their respective row
Use Read Range and the sheet name value as “row(“Category”)” store it in another Datatable
Apply an IF condition to check Master Datatable row(“Name”) = Datatable1 row(“Name”). If it matches then, use write cell activity “C2” “E2” and “F2”
In your IF condition you should use a Counter variable to increment, hence you can pass that value to write cell like this “C”&Counter, “E”&Counter and “F”&Counter