[Solved] Zero out cells

[dobrphi]

I have a cost tracking sheet that I want to modify to use in 2020. Each item has a pair of rows - one is for max allocation and the other is for actual expenditures. There is a cell for each month. I want to copy the sheet from 2019, keep the first row of max allocations and zero out each of the actuals. Seems to me this should be simple but I haven't found a way to do it. I would appreciate any suggestions or help. Thank you.

[RusselB]

Start by highlighting the sheet, then use Ctrl+C to copy the highlighted area.
Next go to your 2020 page/spreadsheet (depending on if you have a page/tab for 2019 and another for 2020 or different spreadsheets for each), then press Ctrl+Shift+V (Paste Special)
I'd suggest checking everything except All and Numbers. Checking All will make the other checkboxes unavailable..
Then click OK.
Now go back to your 2019 sheet and copy any numbers that you want/need that were directly entered into the 2019 sheet, and copy/paste them into the 2020 sheet... this step may need to be done multiple times.

[MrProgrammer]

Each item has a pair of rows - one is for max allocation and the other is for actual expenditures. There is a cell for each month. I want to copy the sheet from 2019, keep the first row of max allocations and zero out each of the actuals. S

Copy the sheet. Then use Data → Filter to show only the actuals, hiding the maxima. Select everything and press the Backspace key. Hidden rows are not affected. Remove the filter.

Read about filters in Help → Index or in User Guides (PDF) or searching for topics about them in the Calc Forum. If you need any further assistance attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself). Explain which rows in which sheet are to be cleared.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[dobrphi]

I tried the Data >Filter suggestion. I didn't have any success. I've attached the spreadsheet for your consideration.

[DiGro]

Some figures were hardcoded in the cells.

See if attached document helps you further.

Pay attention to rows 31 and 32 on sheet Basic because they seem duplicated.
Row 50 refers to sheet Misc so I left that untouched

Atest bdgt.2020-1 v02.ods

Reworked file

(24.02 KiB) Downloaded 92 times

[dobrphi]

Thank you DiGro.. That is what I was trying to accomplish. Rows 31 & 32 were an oversight - 32 should be 0.00