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.
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.