Updating a large sheet - Mass Move or Delete

JMN1012

Hi all,

New to SS so please excuse if this is a very basic question.

We have a lookup sheet that contains around 20,000 rows of data and has Match functions that point to it from other sheets, due to this I do not want to just delete the sheet and create a new sheet each time, then have to go back a recreate the MATCH functions. The lookup sheet needs to be updated once a month with new data.

There seems to no way, auto or manual to delete this many rows. If I select all the rows manually, SS tries, then after a min or so, errors, asking me to not save and refresh. Is there anyway to merge or mass delete in SS? I have even tried to use automation whereas I would I would create a form with a check box, then trigger when the checkbox was checked AND another cell had data to use the move automation, however it seems I need to select a unique value.

This seems the most basic function so where am I going wrong??

Tks

Andrée Starå

Hi @JMN1012

I hope you're well and safe!

Is any of the Premium Apps an option?

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

JMN1012

Thanks @Andrée Starå

This seems to be a very basis task no? Should we have to go to a Premium App for something so basic?

If so, do you have any idea on what App provides this functionality