krishak77
06-18-2019, 11:40 AM
Hello Everyone,
i need yours help for the below situation
In the sheet1 i have multiple serial numbers, and for each serial number i have to check status and mention comment in Sheet2
in Sheet1 first serial number is on cell"L2" and for that status is on cell "A28" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2
second serial number is on cell"L52" and for that status is on cell "A78" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2
third serial number is on cell"L102" and for that status is on cell "A128" as system reject and in the comment cell"E127" we have "Cancelled as Serial number product mismatch", so i have to mention comment as "Cancelled as Serial number product mismatch" in Sheet2
forth serial number is on cell"L149" and for that status is on cell "A175" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2
Sheet1 data i will extract from webpage, so all the time it will be not in the same range.
attached excel file for your reference.
Appreciate for any solution for the above situation.
Thanks in Advance,
Anantha
i need yours help for the below situation
In the sheet1 i have multiple serial numbers, and for each serial number i have to check status and mention comment in Sheet2
in Sheet1 first serial number is on cell"L2" and for that status is on cell "A28" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2
second serial number is on cell"L52" and for that status is on cell "A78" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2
third serial number is on cell"L102" and for that status is on cell "A128" as system reject and in the comment cell"E127" we have "Cancelled as Serial number product mismatch", so i have to mention comment as "Cancelled as Serial number product mismatch" in Sheet2
forth serial number is on cell"L149" and for that status is on cell "A175" as Credit Accepted, so i have to mention comment as "Accepted" in Sheet2
Sheet1 data i will extract from webpage, so all the time it will be not in the same range.
attached excel file for your reference.
Appreciate for any solution for the above situation.
Thanks in Advance,
Anantha