VBA to create a series of calculated outputs from a user defined input list into a new workbook (renaming worksheets)

Condos1

New Member
Joined
Oct 6, 2014
Messages
1
Hi All,
I am new to VBA and am struggling to piece together code to do the following:

1 - Create a overhead statement for each cost centre from a user defined list (Output_List Range A2:A14) in a calculation workbook
2 - Each cost centre in the list is to be copied into cell B6 of the calculation sheet (called "Generic") within the calculation workbook
3 - The result post 2) above (for the first cost centre in the user defined Output_List) is to be copied into a new workbook (i.e. output workbook), summing & % formulas retained, formats/print ranges retained, links to the "Generic" calculation sheet removed on presentation into the output workbook
4 - The worksheet for the new cost centre in the new workbook is named as per the cost centre (reference cell B6, e.g. T001)
5 - A new worksheet for the next cost centre in the list below the previous calculated output is created next to the initial worksheet in the output workbook.
6 - This process is repeated until every cost centre in the user defined list per Output_List Range A2:A14 of the calculation workbook has been processed in the "Generic" calculation worksheet of the calculation workbook and a named worksheet for every cost centre in the Output_List of the calculation workbook has been created in the output workbook
7 - there can be a minimum of 1 cost centre or up to 13 in the loop per my worked example (would like to able to scale this up)

Would be grateful of some pointers on how to piece the steps together (my experience is not far above record and play for VBA presently).
Really appreciate any help you can offer
 

Attachments

  • Generic_calc_sheet.PNG
    Generic_calc_sheet.PNG
    54.5 KB · Views: 10
  • Output_File_Created.PNG
    Output_File_Created.PNG
    93.2 KB · Views: 10
  • Output_List.PNG
    Output_List.PNG
    16.6 KB · Views: 11

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top