LO Calc, How to delete certain rows in spreadsheet automatically
Hi all,
I am doing some taxes for some elderly people & I gave them a spreadsheet to use for charitable giving but now I need to edit it down and have a minor problem.
I need some kind/type of command that will automatically delete certain rows that do not have any items in them.
I know I could do this by hand but it certainly is labor intensive & I worry that I might delete a row through error that they need.
Is there a way to automate this process?
Columns A, B, & C are fixed items/values, Rows 7 & 8 of cols B thru H repeat later on down with different thing in A7.