Hi All,
Like the subject says, I am looking for a way to select a range of cells (or an entire column) and remove cell contents which are not formula's.
I basically produce a monthly report, and each month have to add on a new column to the end for the updated figures so realistically I guess my best solution would be some way of copying and pasting the previous months data but only retaining formats and formulas or alternatively a way to just removed non formula based values from a range of cells - I don't mind how I acheive this, be it through an in-built Excel feature which i'm yet to discover, or alternatively with VBA - Any help would be grately appreciated.
Like the subject says, I am looking for a way to select a range of cells (or an entire column) and remove cell contents which are not formula's.
I basically produce a monthly report, and each month have to add on a new column to the end for the updated figures so realistically I guess my best solution would be some way of copying and pasting the previous months data but only retaining formats and formulas or alternatively a way to just removed non formula based values from a range of cells - I don't mind how I acheive this, be it through an in-built Excel feature which i'm yet to discover, or alternatively with VBA - Any help would be grately appreciated.