Run Module within another database?

[cyborgoddess]

Kind of ... I've thought about parts of the list (calculated 5 year annualized returns, for example) and bringing that back in - which is fine, but I do need to keep a list of the month by month returns. Maybe if I make a cross tab out of the cross tab I can convert it back?

 

[smercer]

I do need to keep a list of the month by month returns.

Then have a third sheet for saving the month by month returns. How the values are transfered could be done in either excel (via macro) or access (via a linked table and append query)

does that help?