I have 500 rows with formulas in them, some of which have calculated values
and therefore there is data sitting in them.

I would like a macro to paste the values of the rows in which data has been
calculated, leaving the uncalculated rows with the same formula in them.

I then need to delete entire rows of the pasted values if a date value
exists in column K.

I have been ripping my hair out over this so any help would be much
appreciated.

Thanks