Hello,
I am trying to build invoices utilizing a excel file and ROW A shows the billing ID and then theres several rows with the description of different pay criteria.
i am trying to make a loop to count the number of rows until the next billing id change in the excel document but having trouble understanding how to do that.
I am utilizing desktop automate for this.
anyone have any idea?
Can you post a screenshot which shows the change in pattern when the billing Id changes?
You need to take for loop and Variable
you logic will be like
for each row in rows
CurrentBillingID = row[billingID]
if(CurrentBillingID equals PrevBillingID)
.......
Else
...... you encountered new BillingID
PrevBillingID = CurrentBillingID