I have inherited a spreadsheet which has been incorrectly updated by a co-worker.
In this spreadsheet there are
two related sheets. The first sheet is an input sheet and contains a series of grouped statements regarding projects. These
are listed in column B. Row 1 columns C to xlend contain project titles.
The idea is that for every project
listed in row 1 an 'x' is input in the corresponding column against each statement in column B if it applies to the project
The second sheet maps all the input cells in the first sheet with a formula which results in a value
if an 'x' appears in the corresponding cell on the first sheet. In this way all the column values are added and each project
ends up with a 'score'.
Unfortunately, when my co-worker was given the spreadsheet to update, instead of updating
the input sheet, he overwrote the sheet containing the formulas with the values that the formulas would have calculated if he
had updated the input sheet!
I have now been given the task to undo all the damage my co-worker has inflicted, to
reinstate the formulas and to update the input sheet instead.
I thought I would be able to identify those cells
containing numerics instead of formulas using the TYPE function, but of course, TYPE works on the result of any formula, and
doesn't return any indication that a formula exists.
What I want to do is to run a macro which examines each cell
in the array and identifies those cells that don't contain a formula. These will be added to a temporary sheet which will
become the input to another macro which will update each cell listed on the input sheet with an 'x'. I can then reinstate
the formulas on the second sheet.
I have searched for a function which will differentiate between cells containing
formulas and values, but to no avail.
Can anyone out there give me a solution?