I have a 15 sheet workbook (template) where raw data is entered onto the
first page and as the physical processes are completed in the factory the
data is cut and pasted to their categories i.e respective Excel sheets in the
workbook. Other than use SPECIAL PASTE/VALUES command how can I enbed the
formula so that it can still run the calculations and not be erased by
pasting?