Excel online Script to move data from one sheet to another (NOT VBA)

[tonywatsonhelp]

Hi Everyone,
I'm hoping someone can help me,
I'm using the new Excel ONLINE scripts and would like a script that can do the following:

On Sheet "Job Log", Filter Range D5 to last row BD using column L as the filter col and filter the word in Cell B2 (You can use "Completed" if that's not possible)
once filtered copy the filtered data from "Job log" to Sheet "Raw Data" pasting it into column D and last row +1

then clear the filtered data in "Job Long" and remove the filter and sort the data by column d,

I'm very new to Excel scripts so would love any help you can give me.

Please note: I AM NOT ASKING FOR VBA CODE! this needs to be the new Excel Script code, please.

any questions just ask

Thanks

Tony

 

[tonywatsonhelp]

anyone,anyone, bauller!