Automation Input Sheet

Automation Input Sheet

Automation Input Sheet

Automation Input Sheet

Automation Input Sheet

Hi There,   I need assistance with a code for VBA macros to automate an input sheet to control and make a copy of my forecast model.   Input Sheet: Project_Scenario_3 Forecast Model:  Subs revenue – Plan – 5 Year R809 FY20 FY21_3   The Forecast model is build with formulas, and i linked them to the input sheet to make changes,   But I require a code to control the forecast with the input and be able to create a copy, without making changes to the original.   Work flow:   Button to create copy of the input sheet and forecast model for any new scenario. and renaming them. The user must be able to push the button, and the folder and files must then be created with a new file name of choice and make changes from the new input sheet using the data in the copy of the forecast model. Changes will be made on pricing and growth of subscriptions and subscribers

Top Contributor Asked 5 days ago in VBA: Macros.
Add Comment
0 Answer(s)
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.