Hi, I would like to ask if there is a way to loop in to rows in a table in excel like assigning data ..., below is my scenario.
Assembly Table below has a blank column for tools, there is need to assign tools for the items based on Cat Code.
The desired out is to assign Tools for the Items in the Assembly table. Notice that there are only 3 rows in each Cat tables (above), tools were assigned per row and once all the rows are already assigned the tool will loop to the top and assign the first row in the Cat table.
Thank you in advance for helping resolving this problem.
