If you don't want to add to workbook 2 later, then once you have the data you
require in workbook 2, highlight the sheet (or the area of data containing
the formulae), copy it and then 'paste special' 'values'. This will remove
the links and just give you numbers in the cells. Save it with a new name
(January or whatever), dont save workbook 2 and you should still have
workbook 2 with the original formulae for next time you run it.

"robzrob" wrote:

Workbook 2 picks up data from Workbook 1. I type data into 1. I want
to be able to save 2 with all its data from 1, then go back to 1,
clear it, but without my saved 2 being cleared, then enter more data
into 1 and save it on a new 2.