I have a timecard tracking spreadsheet that I use for work that consolidates 5 employee timecards onto a department timecard.
The formulas are all good and the timecard works great, except that each week the employees delete the data from the last week and this causes me to have to review the consolation spreadsheet for #value errors. I have to go to each spreadsheet and hit the delete key in order to clear the # value error on the topsheet.
Is there a macro that I can build and run to clear all non-numeric values for the 5-6 data ranges on each of the timecards?
