Hi,
I'm having an excel sheet named 'Box'. In Cell "B7".
I have an info with 'Box1'.
In the area "A10:H100" I have a lot of values calculated by formulas.


What I want is a macro that create a new sheet using the name from "B7"

then copy A10:H100 from active sheet 'box' and then paste special with
only
the values in the new sheet 'box1".


After changing all the values in A10:H100 and "B7" to 'box2' ( in 'box'

)I will be able to have the macro do the same procedure again but this
time paste special to 'Box2' and so on.

Is this possible with a macro or maybe 2 macros?


Thanks
Ingve