Generating calculation sheets whenever new sheets are automatically created

CV12

New Member
Joined
Apr 6, 2020
Messages
32
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi, might have a real complex question here:

My calculation software generates 5 export sheets containing details. For those export sheets i have one calculation sheet that makes results of those calculations.

So i have 'EXPORT1' To 'EXPORT5' that are created automatically. Sheet 1 uses the results of those sheets. Now i also want to have the results of 'EXPORT11' to 'EXPORT15', 21-25, 31-35, 41-45, 51-55 and so on. Is there any way to mass copy sheet 1 so that it uses the results of the upcoming EXPORT sheets?

Sheet 1 is created by me and is always the same. The only thing that needs to be changed is that it uses all the results from EXPORT1-5 to EXPORT11-15 and so on... I want to have a lot of duplicates so doing this manually costs a lot of time. Any way to do this?

Thanks in advance.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

COwen

Board Regular
Joined
Feb 27, 2020
Messages
225
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Can you share a sample of your data and what you're trying to achieve?
 

CV12

New Member
Joined
Apr 6, 2020
Messages
32
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
1586819376158.png


I use 'EXPORT1 to 5' for the results on my first sheet. Now i want to copy this sheet with the same formulas, but 'EXPORT1 to 5' should be changed to 'EXPORT11 to 15' and so on. So i just want to copy this sheet with a fixed addition in the '!EXPORTX'

1586819762276.png


I want to do this automatically because my software program may generate 250 EXPORT sheets which are 50 copy pastes.
 

Attachments

  • 1586819502356.png
    1586819502356.png
    28.1 KB · Views: 5

CV12

New Member
Joined
Apr 6, 2020
Messages
32
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
1586820021834.png


I want to use this table on the original sheet that is made by me. In the formulas i refer to this table so it knows to use the results from those sheets. So i want to duplicate this sheet (many times) and add +10 to every EXPORT every time a duplicate is made. Hope i'm clear enough :)

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,129,876
Messages
5,638,788
Members
417,052
Latest member
Noobest

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
Top