Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro to copy rows into worksheets
Ill try to explain best I can.
Recently found (finally..) a macro to auto create worksheets named after whats in Column A (5 digit number). I have one master worksheet and now 47 sheets titled with each ID from column A. Now I have 47 rows with information on the master worksheet and 47 empty worksheets. How do I put each row into each worksheet? ... Worksheet one will contain row 2, worksheet 2, row 3 etc etc. I should also mention that row 1 is the header(?) says the titles ...that should be copied in addition to each row. make sense? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy rows into worksheets
Hi,
Where in any of the 47 worksheets should rows(2,3,...n) from master sheet be positioned? Second row fixed position I would suppose. Pascal |
#3
|
|||
|
|||
Quote:
Yes 2nd row in each sheet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy rows into worksheets
Hi,
Am Tue, 24 Jul 2012 18:55:36 +0000 schrieb cupcakex: Yes 2nd row in each sheet following code copies the header and the rows to each sheet: Sub CopyRows() Dim i As Integer With Sheets(1) For i = 2 To 47 .Rows("1").Copy Destination:=Sheets(i).Range("A1") .Rows(i).Copy Destination:=Sheets(i).Range("A2") Next End With End Sub Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#5
|
|||
|
|||
Quote:
AMAZING!!!! you have saved me so much time thank you x10000000!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Rows with a cell value 0 from several worksheets to a new sh | Excel Worksheet Functions | |||
macro to copy multiple rows to separate worksheets | Excel Worksheet Functions | |||
Macro simplifying - copy rows to worksheets based on values in 2 different columns | Excel Programming | |||
Copy rows from different worksheets | Excel Programming | |||
Subject: Macro- Copy same rows into own worksheets | Excel Programming |