Save and open data for Workbook?

[Kranken]

I have made a fairly large financial model but do not wish to save th
model in one copy per transaction. Rather I would like to be able t
save the data only. I would also like to be able to open up previousl
saved data into the model and be able to modify them.

Any good tips on how to solve this?

Kranke

 

[Dave Peterson]

This might work if your model is static--not too many changes/updates to layout.

Insert a new worksheet in your model workbook--call it Input.

In column A, put a short description of the response that should go in column B.

Then in the calculation sheet(s), use a formula that retrieves those values:

=input!b2

Then when you want to save one set of data, just save that worksheet as a .csv
file. If you need to retrieve data from a previous run, open the .csv file,
copy|paste special|values onto the Input sheet.

Be aware that if your layout changes, you could break things.

Say you insert a new row to get additional data, then when you paste the old
data, things are by a row!

You may want to put a version number in row 1. Then you could have another
routine that would update each of your .csv files if you update the model.

(Like inserting a new row with a nice default response.)