How-to-Formula Copying Numbers from rows to rows

joram7

Board Regular
Joined
May 12, 2005
Messages
115
Book2
ABCD
13091650549
2
34312975094
4
5
6
7
84312975095
9
10
11
124312975096
13
14
15
16
17
18
19
20
21
22
234312975097
24
254312975098
26
Sheet1


As above i need to copy e.g. 3091650549 to A2 then 4312975094
up to A7 then copy 4312975095 up till A11. this will repeat until end of the line.
Is there a macro or formula for this?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Barrie Davidson

MrExcel MVP
Joined
Feb 10, 2002
Messages
2,330
Why not try this:
B1 formula =A1
B2 formula = IF(A2="",B1,A2)
Copy this to the end of data range
Copy column B and paste values to column A.

Does this help you out?
 

Krishnakumar

Well-known Member
Joined
Feb 28, 2003
Messages
2,615
Hi,

Code:
Sub FillBlanks()
    With Columns(1).SpecialCells(xlCellTypeBlanks)
        .FormulaR1C1 = "=R[-1]C"
        .Value = .Value
    End With
End Sub

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,114,037
Messages
5,545,665
Members
410,697
Latest member
srishtijain0708
Top