Hi

I need some help to create a new sheet and expand my formula so i calculates on the the sheet. The structure is going to be the same on every new sheet. So i want to:

1. Create a new sheet and name it P2, and copy the struture from my overview. This i have the code to.

2. I want in my overview formula to expand the formula (sumif on the picture) to sum on the new sheet.

Capture1.JPG

Thanks in advance

/ Martin