Tired of Typing the Same Formula over and over again

[gwehner]

I have a report I compile every Monday morning. There are only two formula I use for it - an If statement and a Vlookup. Both evaluate the same columns and files each week. I am tired of typing them every week.

What is the quickest way to insert the formula into my sheet each week?

Here are the formulas for ref:

=If(C2=0, B2&" - "&G2, B2&" - "&C2&" - "&G2)

and

=Vlookup($A2, '[keydatatable.xls]keydata'!$L:$N, 3,False)

Thanks for your help.

 

[Norie]

Can't you just copy and paste them?

 

[Lewiy]

Can you not use a template for this report with the formulas already in?

 

[njimack]

You've already been given 2 suggestions which would work, but I note that your first formula could be rewritten as:

=B2&"-"&IF(C2<>0,C2&"-","")&G2

 

[Big Monkey]

You could also write a macro or two to input the formulas you need in the active cell (if you need to spot input formulas) and then assign shortcut keys