Create new sheet from cell-info and then copy/paste special

I

Ingve

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

And yes: the original data that I want to copy and the "B7" are always
from the sheet named 'Box'

Is this possible makin in VB?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy from active sheet and paste into new sheet using info from cell in active 3
Create a dynamic master file 1
Create if partial match then copy and paste data from one cell to another 1
Search , then copy and paste from multiple worksheets. VBA help 1
how to copy and paste value from one sheet to another 4
hidden rows, column copy-paste 0
How to do this with macro? 2
Find values of a column in another and paste range of rows 1

Top