Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filling every tenth row
I have data on wrksht(A) and need to copy to wrksht(B).
wrksht(a)A1 to A1 on wrksht(B) wrksht(a)A2 to A11 on wrksht(B) wrksht(a)A3 to A21 on wrksht(B) wrksht(a)A4 to A31 on wrksht(B) and so on. Help!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filling every tenth row
try this
Sub copytoten() counter = 1 For Each c In Range("a1:a100") c.Copy Worksheets("sheet2").Cells(counter, 1) counter = counter + 10 Next End Sub -- Don Guillett SalesAid Software "Salim" wrote in message ... I have data on wrksht(A) and need to copy to wrksht(B). wrksht(a)A1 to A1 on wrksht(B) wrksht(a)A2 to A11 on wrksht(B) wrksht(a)A3 to A21 on wrksht(B) wrksht(a)A4 to A31 on wrksht(B) and so on. Help!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
filling every tenth row
for rw = 0 to 10 wsB.cells(rw*10+1,"A").Value = _ wsA.Cells(rw+1,"A").Value next Patrick Molloy Microsoft Excel MVP -----Original Message----- I have data on wrksht(A) and need to copy to wrksht(B). wrksht(a)A1 to A1 on wrksht(a)A2 to A11 on wrksht(B) wrksht(a)A3 to A21 on wrksht(B) wrksht(a)A4 to A31 on wrksht(B) and so on. Help!! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete cells with 0 as the tenth digit | Excel Worksheet Functions | |||
Format cells with 0 as the tenth digit | Excel Worksheet Functions | |||
ROUND() to tens or hundreds (not tenth/hundredths)! | Excel Worksheet Functions | |||
How do I set up a formula in excel that is the tenth root of 7 ve. | Excel Worksheet Functions | |||
Filling every tenth row. | Excel Programming |