help with excel (maybe macros)
 

you guys are the most technical people i know, so i thought i would
bring this to you. his is my problem:

i have data in an excel sheet. its in a matrix and reads from left to
right and top to bottom, as if you were reading a book (A1, B1... A2,
B2... etc).

A B C D E
1 . . . . .
2 . . . . .
3 . . . . .

i need to somehow transfer this to another part of the sheet in excel
and have all my data in one column:

A1
B1
C1
D1
E1
A2

i know i can do this by just making a certain cell equal to another
cell, etc, but i have 4 new data files a day and thousands of data
points per file. so, i need some sort of formula or a macro that can do
this, but im not quite sure how to get this done.

can anyone help? or refer me to someone that might be able to?

i hope this makes sense.


--
laskuh

laskuh,

This macro will take the data in the range A1:C9 and load it into column E
while ignoring any blank cells in the original range:

Sub RangeToColumn()
Dim Rng1 As Range
Dim Rng2 As Range
Set Rng2 = Range("E1")
For Each Rng1 In Range("A1:C9")
If IsEmpty(Rng1.Value) = True Then GoTo Branch:
Rng2.Value = Rng1.Value
Set Rng2 = Rng2.Offset(1, 0)
Branch:
Next
End Sub

----
Regards,
John Mansfield
http://www.pdbook.com


"laskuh" wrote:


you guys are the most technical people i know, so i thought i would
bring this to you. his is my problem:

i have data in an excel sheet. its in a matrix and reads from left to
right and top to bottom, as if you were reading a book (A1, B1... A2,
B2... etc).

A B C D E
1 . . . . .
2 . . . . .
3 . . . . .

i need to somehow transfer this to another part of the sheet in excel
and have all my data in one column:

A1
B1
C1
D1
E1
A2

i know i can do this by just making a certain cell equal to another
cell, etc, but i have 4 new data files a day and thousands of data
points per file. so, i need some sort of formula or a macro that can do
this, but im not quite sure how to get this done.

can anyone help? or refer me to someone that might be able to?

i hope this makes sense.


--
laskuh