How to update status columns

Help Studio
, ,
5

@suraj_gaikwad

correct me if my understanding is wrong,

you are doing your some process with SEBI sheet data and updating the status in Status column with in the same sheet!!.
Now you need to update Status in Main sheet based on SEBI sheet Status column Right…?

If that’s right…

  1. After completing the all your process related SEBI sheet.
    2.Read your SEBI sheet data
    3.Read you Main Sheet data
    4.Use loop for Main sheet data
    5.Get the Client code from Main sheet
    6.filter Sebi sheet data with Client code
  2. Now make one condition all of the values are DONE or not
    8.If Yes use write cell and give value and range of the Column.
    (Note: while giving the Index make sure you are passing correct index)
1 Like