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 |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com