Relative Content

Tag Archive for javascriptexcelscripting

Office script to get data from table, filtered data and pasted into a new tab and new table

I have been trying to extract filtered data from my “PMs” table in my excel, I need to filter column D for statuses that are equal to “WSCH” or “WAPPR” or “INPRG” and filter column H with values equal or less to 7, once the filter has been applied, create a new tab and paste the filtered data into a new table called PM On Risk, I have tried it for several days but I can’t get it.