Automating an editing task

I prepare and maintain project budgeting spreadsheets. Every month I have to set the values in certain cells pack to zero. The spreadsheet consists of four or five worksheets with identical labels in Column A but different number inputs in Column B. Each month I have to go back and enter a zero in 40 to 50 cells.

My question: Is there a way to automate this task?

Thanks!

There are many was to do this. The problem is which way is best for you?

What determines which values in B should be set back to zero?
Is it a one sheet task or are all of the sheet affected?

Originally Posted by mdbct

There are many was to do this. The problem is which way is best for you?

What determines which values in B should be set back to zero?
Is it a one sheet task or are all of the sheet affected?

Column A

Budget Hours
Hours Spent
Hours Remaining

These three rows are repeating down the column. Sometimes there are 40 - 50 sets of these lines. At the end of the month I need to enter a zero in all of the

Hours Spent

There is a worksheet label Week1, Week2, Week3, Week4, MTD. The MTD worksheet is simply a sum of the other worksheets, so I don't need to zero anything on that sheet, only the weekly sheets.

I hope this makes my situation clear.

Thanks!

The following will loop through the sheets and change any value in the B column to 0 (zero) where the value in the a columns contains "Hours"

Please Login or Register  to view this content.