google sheets - how to - Automatically Move Row down Based On Dropdown

zenki1
New Member

Hi, I am new to Google Sheets, Can someone help me with the code to move the entire row to an other certain row if I change the Column F to 'done'.

ExampleAฬ‰nh chuฬฃp Maฬ€n hiฬ€nh 2024-12-18 luฬc 16.56.52.png : if i change F3 to 'done' then entire row 3 will be automatically moved to after row 40
Note : Filter function did not work in this case for us ^^ i tried macro but... had to active macro manually ^^ , it would be great if a script that help to do it automatically, thanks for any help

0 1 314
1 REPLY 1
Top Labels in this Space
Top Solution Authors