Excel 2007 : Importing Data that changes

[fanleaf]

Hi,
I have set up a workbook with financial data that I import from an online source in csv format. I have set up formulas that do rather basic things with the data. My question is how do I preserve the formulas when I import new data to my setup. I to want overwrite the data but preserve the formulas.

Using Excel 2007.

Thanks for your help.
Fanleaf

[JBeaucaire]

Import into a separate worksheet, then bring the new data over into evaluation position.

[fanleaf]

Thanks JBeaucaire. That's so simple and I guess I was thinking something complex and overlooked the obvious.
Fanleaf

[JBeaucaire]

Thanks JBeaucaire. That's so simple and I guess I was thinking something complex and overlooked the obvious.
Fanleaf

Shame to admit, I do the same thing all the time. That's why we need each other's fresh perspectives. Go team!

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)