How to update status columns

[prashant1603765 (Prashant Kumar)]

@suraj_gaikwad

I have an excel file there is multiple sheets and one Main sheet. In child sheets there is data which i have to proceed and there is status column l.

For in sheet 'sebi csv ’
1
1
1
2
3

These are my transactions then i have to process which are same (1) then each transaction i have to update as done,failed,done

If all three done then marke as a success in MASTER sheet
If one of them is failed then mark as a partially done

Thanks

Hi @suraj_gaikwad

Read data from the 'sebi csv sheet, loop through the Status column (L) for each transaction, and process the transactions marked as 1. Update the status as Done or Failed for each transaction. If all are marked as Done, update the MASTER sheet as Success; if any is Failed, mark it as Partially Done in the MASTER sheet. Finally, save the Excel file.