| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from active sheet and paste into new sheet using info from cell in active
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy sheet and make new sheet active | Excel Discussion (Misc queries) | |||
| copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
| Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
| Create new sheet from cell-info and then copy/paste special | Excel Programming | |||
| To copy from a range in another sheet to the active cell | Excel Programming | |||
Threaded Mode
