patilbhush007
New Member
Hello Everyone
Below I have attached some screenshots regarding the output I am trying to achieve.
What I am trying to do is:
1) Based on sheet 1 and sheet 2 common column which is ID. Selecting ID from first column(sheet1) and filtering with same id in sheet2(column1).
2) Once I get the filter data check for checkbox value from home tab in below example its 1 Auth if true then find the value in sheet2(column3). With respect to checkbox value if found in column 3(Sheet2) then only go to column 12(sheet2) and update value do this multiple time if checkbox value occurs more than 1. Do this till last row in sheet1(column1).
3) After updating value in column12(sheet2) check for next column13 if has similar value then change to the value from column 12.
Any help is much much appreciated.
Below I have attached some screenshots regarding the output I am trying to achieve.
What I am trying to do is:
1) Based on sheet 1 and sheet 2 common column which is ID. Selecting ID from first column(sheet1) and filtering with same id in sheet2(column1).
2) Once I get the filter data check for checkbox value from home tab in below example its 1 Auth if true then find the value in sheet2(column3). With respect to checkbox value if found in column 3(Sheet2) then only go to column 12(sheet2) and update value do this multiple time if checkbox value occurs more than 1. Do this till last row in sheet1(column1).
3) After updating value in column12(sheet2) check for next column13 if has similar value then change to the value from column 12.
Any help is much much appreciated.