Storing formulas

Simon Hanlon

If you have favourite formulas that you will use on multiple sheets can they be stored as template formulas or do you have to copy from a sheet each time you want to use the formula?

Richard Rymill SBP

Hi Simon

you can do both of these and we call our favorite formulas Awesome formulas. 

The other thing you may already know, but  if when you have a full workflow of sheets and reports in a Folder with lots of Cell Linking and interaction, if you "Save as New" from a prepared "Empty one" but which would include Formulas, you can speed things up no end in setting up similar workflows.  Apologies if you knew all that already. 

Hope that helps

RichardR 

ps we are in the UK to if you wanted to discuss? 

Simon Hanlon

Many thanks Richard. How do you save/store an 'Awesome' formula?

 

Simon

Richard Rymill SBP

Simon

let me have your email address and I will share it with you. 

 

Regards

RichardR@smarterbusinessproceses.com

 

Simon Hanlon

Thanks Richard. You can reach me at shanlon@ocrf.co.uk.

 

Regards

 

Simon

Richard Rymill SBP

Hi Simon

Simon I am sharing the sheet with you now.

 

If you could save as New so you have your own copy and remove yourself from sharing that works for me. 

 

Regards

 

Richard Rymill

01937 541 553 if you ever need to talk, we are in Leeds.