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.
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.