Hi Everyone,
I'll try to make this short and sweet.
I'm working on a financial modeling project and need a little help. I've been developing a financial model in excel using an add-in called Spreadsheet Server, which links to accounting software and allows you to pull in financial data by using a formula with several parameters.
The model is complete however I'm wanting to create a macro to loop through the cells on each tab of the model, and replace the Spreadsheet Server add-in formulas with values. In other words, I want standard excel formulas to stay intact while the add-in formulas will be copied over as values. This way we can send the model to other users who don't have the SS add-in and they can still manipulate it. A common theme to the SS add-in formulas is that they all are written as GXL(parameter, parameter, etc.). I figure there has to be a way I can loop through each cell, find if it contains "GXL" in the written formula, and then copy that cell as a value.
I'm having a little trouble figuring out what is the best method to take that will accurately find every applicable cell and copy it as a value efficiently (I have over 50 tabs in which I will need to copy values so run-time speed is important.) Any ideas?
Many thanks in advance,
godawgs85