Ask your question Print Format Forum list Help them Statistics Search Charter Forum Programming

Statut : Solved

Macro to populate worksheet tabs

pujamaa, on Tuesday 8 April 2008 à 13:49:24

Hello,

Can somebody post the code necessary to copy a template tab into X new sheets, and renaming each sheet Test 1, Test 2, to Test X ?

Thanks!

Configuration: Windows XP
Internet Explorer 6.0

Reply to pujamaa Report this message to moderators Go to last message

1This message seems useful, vote!
Ce message ne vous semble pas utile, votez !
Report this message to moderators

soft.8, on Tuesday 8 April 2008 à 16:22:59

Hello

sub a ()
DIM i As Integer
Dim s As worksheet
set s = Sheets (" template")
For i = 1 To InputBox ("Number of copies?", "NEED INPUT!", 5)
s.copy after:=sheets (sheets.count)
Sheets (Sheets.Count) . Name = "Test " & i
Next
End Sub

Reply to soft.8

Ask your question Reply

Résultats pour Macro to populate worksheet tabs

Excel Macro Help Hello, I am writing a macro which will hopefully auto populate some employee information, from a summary sheet, where each employee has their own sheet within the workbook. This will need to be done by month and year, which I have identified as... en.kioskea.net/forum/affich-19544-excel-macro-help

Remov Blank Cel Frm Col A & Hav 2 rite in B Hello, I need to remove blank cell from column A & need to write in Column B. With out disturbing the Column A alone (Coz To populate data in Col A i'm using some formula). I used a macro , Private Sub Worksheet_Calculate()... en.kioskea.net/forum/affich-28496-remov-blank-cel-frm-col-a-hav-2-rite-in-b

Excel macro: copy between sheets Hello, I have sheet1 and sheet2. I want to create a macro: -copy Bx:Dx from sheet1 to sheet2 Bx:Dx -where x from 6 to "get count row number, where cell is not null" Thanks, Gediminas en.kioskea.net/forum/affich-25484-excel-macro-copy-between-sheets

Résultats pour Macro to populate worksheet tabs

Excel Macro Help Please (Solved)Hello Everyone, I am sking for some help with an Excel macro please. I have a 1,900 hundred static HTML pages that I have converted to text for the purpose of importing to a DB via an Excel CSV file. I have everything sitting in an excel file now with... en.kioskea.net/forum/affich-11146-excel-macro-help-please

Excel Macro; Adding Password (Solved)Hello, Hope you anyone can help me with this... I need to create a macro that unlocks a password-protected sheet with password "password", do some instruction, then locks it again with same password. Thanks in advance for any assistance. zero en.kioskea.net/forum/affich-17268-excel-macro-adding-password

Need help in Excel Macro (Solved)Hello Ivan, Ive' been reading a lot of your answers and i'm quite facinated of your skill. I need to create a macro for one of my project and it involves tranferring data (row) to specific range in another work sheet. I tried to produce a... en.kioskea.net/forum/affich-17266-need-help-in-excel-macro

Résultats pour Macro to populate worksheet tabs

Download ZDTIt is not any more to add that China counts the most well brought up population in the world, with about 2 billion inhabitants. Then the study of this language became very spread. The ZDT (Zhongwen Development Tool) is an easy tool of use allowing... en.kioskea.net/telecharger/telecharger-804-zdt

Download Shockwave playerAdobe Shockwave Player (in the past Macromedia Shockwave player) is one plug-in allowing' to post Shockwave animations in the majority of browsers known! en.kioskea.net/telecharger/telecharger-1198-shockwave-player

Résultats pour Macro to populate worksheet tabs

'Spore' computer game's alien population explodingThe "Spore" alien population is exploding, boding well for the September launch of the latest brainchild of computer game legend Will Wright, seen here The "Spore" alien population is exploding, boding well for the September launch of the latest... en.kioskea.net/actualites/spore-computer-game-s-alien-population-exploding-10539-actualite.php3

China's online population exceeds the US: reportChinese gamers are seen playing online computer games at an internet cafe in Shanghai, in 2007. China's online population has become the largest in the world after it reached 221 million in February, outnumbering Internet users in the United... en.kioskea.net/actualites/china-s-online-population-exceeds-the-us-report-10318-actualite.php3

China's Web users top 250m on back of disasters, OlympicsA woman surfs the internet at a cafe in Beijing in January 2008. China's online population, already the world's largest, has swelled to 253 million, an official report said, driven by news events such as natural disasters and the Beijing... en.kioskea.net/actualites/china-s-web-users-top-250m-on-back-of-disasters-olympics-10567-actualite.php3

Résultats pour Macro to populate worksheet tabs

HTML - Paragraphs HTML considers paragraphs to be blocks of text. Browsers do their best to fit the contents of paragraphs into the window, unless the NOWRAP or NOBR attribute is explicitly specified. Within a paragraph, all spaces, tabs, and line breaks each count as... en.kioskea.net/html/htmlparagraphes.php3

Processes - cdantsrv - cdantsrv.exe The process cdantsrv.exe is part of the C-Dilla License Management Software Macrovision suite, used for digital rights management (DRM), i.e. managing access rights for copyright-protected content. The file that corresponds to this process is... en.kioskea.net/processus/cdantsrv-exe.php3