Quicker could be a set of macros that wrote the formulas for you.

Really quick would be to create a Template to import the data into.

The formulas would already be in place.......just need the data.

To create the Template, open a new workbook.

Format and enter the formulas where you will need them.

Save As Template(*.xlt) in 2003 and earlier or (*.xltx) in 2007.

Sort of quick would be to have a sheet with the formulas written preceded by
an apostrophe to make them Text.

When needed, copy and remove the apsotrophe.


Gord Dibben MS Excel MVP


On Thu, 14 Jan 2010 11:23:02 -0800, Kate
wrote:

Is there a way to access frequently used formulas easily? I have a report
where I need to import the data and then type in the same formula each time
in order to create analyzable results. Is there a quicker way?

Thanks