Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving Excel Formula

Status
Not open for further replies.

ebisabes

Technical User
Aug 11, 2006
71
US
If I have a formula I use quite often (or more than one) is there a way to save that particular formula so I don't have to type it in everytime? eg:

=if(A1=A2,"oops","")
 
Do you mean a way to avoid having to type it into each row?

I think you mean you have a similar spreadsheet every day and you want to be able to populate the same column with the same formula every day. If that's the case, you'll want to use a macro. You could have the macro assigned to a button on a custom toolbar.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
I really don't see the point in saving such a short formula but if you want to make it shorter, this will provide the same logical answer

=A1=A2

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
The problem with saving and copying the formula, your cell references will probably be changing anyway and you will have to edit it each time. If that doesn't bother you, then save it to note pad and ctrl-c/v it as needed.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
I thought that was just an example. If the formula is that short, I definitely wouldn't bother using a macro.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top