Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split or copy records n-times as excel scans the value of a colum
I would like to split or copy record n-times based on n-value on of a row.
How do you contruct the loop? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split or copy records n-times as excel scans the value of a colum
Perhaps a simple typo issue, but I cannot figure out -- from the precise
wording -- what you require, please be a little clearer. I would love to help if I can. Bill Benson "Loops" wrote in message ... I would like to split or copy record n-times based on n-value on of a row. How do you contruct the loop? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split or copy records n-times as excel scans the value of a colum
Sub AAA()
Dim i As Long, Num As Long i = 1 Do While Cells(i, 1) < "" Num = Cells(i, 1) Cells(i, 1).Offset(1, 0).Resize(Num).EntireRow.Insert Set rng = Cells(i, 1).Offset(1, 0).Resize(Num) Cells(i, 1).EntireRow.Copy Destination:=rng i = i + Num + 1 Loop End Sub -- Regards, Tom Ogilvy "Loops" wrote in message ... I would like to split or copy record n-times based on n-value on of a row. How do you contruct the loop? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Text to Columns - Only want to split SPECIFIC NUMBER of times | Excel Worksheet Functions | |||
How do I stop virus scans when loading existing Excel files?? | Excel Worksheet Functions |