- or download this
Rows("1:1").Select
Selection.Copy
Rows("2:2").Select
Selection.Insert Shift:=xlDown
- or download this
1: Cell1, Cell2, Cell3
2: Data1, Data2, Data3
3: Foo01, Foo02, Foo03
- or download this
1: Cell1, Cell2, Cell3
2: Cell1, Cell2, Cell3
3: Data1, Data2, Data3
4: Foo01, Foo02, Foo03