Forum Discussion
Solved
help with deleting all rows but header when column has a cell that contains 0
I have many cells that have a zero in them in column D and I want to delete the entire row if there is a 0 in column D, but the data size will change so I need it to also not be conditional on the ex...
I guess I tried to answer in another your post https://techcommunity.microsoft.com/t5/excel/auto-fill-in-office-script-api/m-p/3915532#M203345
It was phone reports where the rows that had a 0 in them were calls that were dropped/ didn't get through because it was ringing to all phones in the ring group. it truly was unneeded data that needs to be deleted so that the spreadsheets are smaller because they will all be combined into one huge spreadsheet for the year to be created into a report. My question was answered and I did get help with fixing the code but thank you for your kind reply and help.
blairwebb ,you are welcome, thank you for the clarification.