Collumns

[Guest]

I have multiple collumns of information that I want to compile into a list.
The number of rows in each collumn are variable. SO I might have 3 entries
in a collumn today, while, tomorrow I may have 7.

Collumn A Collumn B
1 a
2 b
3
4

Ideally I want my list to look like
Collumn A
1
2
3
4
Collumn B
a
b

Allowing the starting point for collumn B to vary based on when Collumn A
actually ends. This list has to be printable, and I can't have large
spaces where blank information is just because an item was listed there last
week while today there is none.

 

[Guest]

Try this simple macro:
Sub test()
Range("B1:B" & Columns("B").End(xlDown).Row).Cut _
Destination:=Range("A" & Columns("A").End(xlDown).Row + 1)
End Sub

Regards,
Stefi


„Static†ezt írta: