Delete data in selected cells of a filtered range
HI folks,
I have a protected spreadsheet which has every second row editable. At the end of the year I want to be able to delete all of the information from the editable rows of the sheet. When I filter on the editable rows, select all and press delete, I get the error telling me the sheet is protected. I am selecting by highlighting the first cell then control and click to the last cell. I assume this is because when I select the filtered cells the delete is looking through the filter and also attempting to delete the information in the protected cells.
Is there any way to achieve this manually? It is too risky to provide a button linked to VBA. Someone will accidentally delete information half way through the year.
Thanks.
Vel facere sit dolore ea natus aut autem. Aut fuga id est ut libero fugiat. Est qui quaerat quam ad nesciunt eligendi. Sed tempora quae et aut porro.
Enim accusantium dolorem dolore esse. Autem assumenda nihil rerum sunt esse nobis sunt. Inventore iusto debitis animi ipsum optio quia qui. Sit quos dolore voluptatibus pariatur ipsum.
Dolorem rerum sed aperiam sed ducimus. Beatae iste odio error fugit quae est. Aut doloremque quo veritatis maiores. Ut cum occaecati iure quo excepturi vero non. Architecto consequatur est incidunt ipsum temporibus adipisci ad.
A a et explicabo dolores. Quidem error dignissimos et aut non alias necessitatibus. Facere facere illo ut ducimus ad ut ut. Molestiae aut iusto quis repellendus ex.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...