I'm trying to copy the result of a particular formula to another sheet
within the workbook. I need to set this up within a macro, so that the weekly
results will be stored on another sheet, and the new weeks results can be
entetred but the only function I can find similar to this is the "Freeze
cells" which enables me to change the origin cell from the formula to the
result, but not to change the destination cells.