Hi All,
its the first time am submitting to this forum and am glad to be a member.
I needed help on how can i clear contents of a row when a condition is met in sheet 1 and copy same to sheet2 as a records.
e.g when order status is CLOSE then it shall copy the data to sheet 2 as a record and clear the content on sheet 1.
Thanks to find attached file .
Many thanks in advance for help.
Regards,
Vishals
its the first time am submitting to this forum and am glad to be a member.
I needed help on how can i clear contents of a row when a condition is met in sheet 1 and copy same to sheet2 as a records.
e.g when order status is CLOSE then it shall copy the data to sheet 2 as a record and clear the content on sheet 1.
Thanks to find attached file .
Many thanks in advance for help.
Regards,
Vishals