Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create new sheet from cell-info and then copy/paste special
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a copy/paste special/transpose macro? | Excel Discussion (Misc queries) | |||
Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) | |||
Copy Paste Special Link Cell Problem | Links and Linking in Excel | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |