G
Guest
Here's my situation, I have largely horizontal spread sheet, with vertical
info as well, we are trying to consolidate all info into 1 vertical column,
is there a way to copy each cell from sheet 2 in a range of rows i.e (8:100)
and then copy that into colum A of sheet 1?
Sheet 2 example
a b c d e f g h
i j k l m n o
p q r s t
u v w x
y
z
then need this transfered into sheet1 as
a
b
c
d
e
f
g
....
Please help.
info as well, we are trying to consolidate all info into 1 vertical column,
is there a way to copy each cell from sheet 2 in a range of rows i.e (8:100)
and then copy that into colum A of sheet 1?
Sheet 2 example
a b c d e f g h
i j k l m n o
p q r s t
u v w x
y
z
then need this transfered into sheet1 as
a
b
c
d
e
f
g
....
Please help.