Follow

Copying Worksheets & Full Budgets

Worksheets: 

To make a copy of an individual worksheet you will need to: 

  1. Start at the Home Page mceclip0.png
  2. Click Budget mceclip1.png
  3. Click Full Budget mceclip2.png
  4. Click Worksheet mceclip3.png
  5. Click Copy or Rename mceclip4.png
  6. Select Copy Worksheet Group option mceclip5.png
  7. Select the worksheet that you want to copy 
  8. Enter a new name for the copied worksheet so you distinguish between the old and the new worksheets 
  9. Click the Green Tick mceclip6.png

Repeat for each worksheet for which you want to create ‘What If’ scenario’s.

mceclip16.png

Full Budgets:

To copy a Full Budget and all the worksheets and Grain Income Calculators, you will need to:

  1. Start at the HOME PAGE mceclip8.png
  2. Click BUDGET mceclip9.png  
  3. Click FULL BUDGET mceclip10.png  
  4. Click COPY BUDGET mceclip11.png
    mceclip14.png

Options – You can choose to shift dates forward 1 year if full budget is to be used for a future year. Choose copy attached worksheets to also copy all worksheets attached to this budget. 

To see what worksheets are attached to a budget, go to CHANGE BUDGET SETUP mceclip15.png  and view which worksheets have been selected to be included on the new budget.

 Prefix & Suffix 

Copied worksheets and Grain Income sets have to be renamed as well. Instead of separately naming all worksheets and Grain Income Calculator sets, you can choose to add text to either end of the existing name i.e. a prefix will be added to the beginning and a suffix will be added to the end. (e.g. Prefix: Plan B Cropping 19/20 or Suffix: Cropping 19/20 Copy)

 We strongly recommend you rename your worksheets after you have copied a year forward and if you used either a prefix or suffix, because you will otherwise end up with worksheet names that don’t make much sense  

 

 

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments