Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 14th 10, 07:23 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 112
Default Frequently used formulas

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

  #2   Report Post  
Old January 14th 10, 08:13 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,204
Default Frequently used formulas

I'm not sure this will work well for you, but it might be worth a try.

Why not create a workbook with just the formulas in place, but without the
data? Then you'd open that workbook, import the data into it and save it out
with a new name?

If that's not good for you, perhaps simply copying the formulas into a
notepad (.txt) file and saving it so that you can open it and copy and paste
from it later?

One other way I could think of IF the formula is always typed in the same
way, into the same cell(s) and using references to the same cells to get
its/their values from would be to Record a Macro while entering the
formula/formulas -- when you start recording it, give it a
easy-to-remember-meaningful name and save it into your PERSONAL.xls workbook,
so that it is always available to you no matter what workbook you have open.
Then execute the macro/macros when you need to enter those exact same
formulas in the same exact locations in a new workbook.

"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

  #3   Report Post  
Old January 14th 10, 08:44 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Frequently used formulas

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2nd most frequently occuring value Singh Excel Discussion (Misc queries) 3 March 2nd 09 11:35 PM
building formulas that change frequently using named cell ranges Sheldon Excel Worksheet Functions 4 December 6th 07 04:35 PM
I need to determine how frequently two values appear together Alfie Excel Discussion (Misc queries) 2 December 21st 06 01:41 AM
most frequently occurring value Pivotrend Excel Discussion (Misc queries) 3 December 23rd 05 11:57 AM
How to set up my EXCEL so it takes me to most frequently used directory? Y T via OfficeKB.com Excel Discussion (Misc queries) 1 August 8th 05 08:08 PM


All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017